Results 1 to 3 of 3
  1. #1
    Newbie
    Join Date
    February 22nd, 2006
    Posts
    1
    How do I source HTML as a field in Excel Spreadsheet
    This may be the stupidest newby question ever, but I am using an Excel spreadsheet as my input source and I have a field that is HTML formatted text. It contains <p>, <h3>, and the text itself has quotation marks and other characters that English text normally has in it. When I try to source in this data from the spreadsheet I just get "<p> as the input. (The actual text field in Excel begins with <p> without the leading quote.) How do I source HTML source in a text field in a spreadsheet?

    Mark

  2. #2
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    Hi Mark, and welcome to ABW !

    No questions are stupid, in-fact your question sounds pretty good to me. My first suggestion is something you may have already tried. Tick the "Text values are in quotes" check-box found on the "Sources" tab in WebMerge. If it has been checked, then un-check it.

    The next thing I would try is to use the "Raw" option in your template tags, where you need the text rendered just like it is in the spreadsheet.

    Take a shot at it, and let us know how (if) it works.

    Fred

  3. #3
    Newbie
    Join Date
    March 28th, 2006
    Posts
    10
    (Deleted) Sorry, wrong thread

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Sortable Excel spreadsheet on the web
    By Celicaphile in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: April 11th, 2006, 05:01 PM
  2. html in Excel?
    By bsnrjones in forum WebMerge (Fourthworld.com)
    Replies: 1
    Last Post: January 20th, 2004, 08:07 PM
  3. Building a Site from an Excel Spreadsheet
    By Lionstail in forum Programming / Datafeeds / Tools
    Replies: 4
    Last Post: February 2nd, 2003, 10:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •