topic Load from Excel file with embedded labels containing multiple lines in QlikView https://community.qlik.com/t5/QlikView/Load-from-Excel-file-with-embedded-labels-containing-multiple/m-p/354299#M706436 <HTML><HEAD></HEAD><BODY><P>I'm trying to produce a script to load from an Excel file with embedded labels containing multiple lines, e.g. attached file. </P><P></P><P>The script produced by Table Files button includes carriage return characters within the field name, e.g.</P><P></P><P>LOAD [Column</P><P>Heading]</P><P>FROM</P><P>Book1.xlsx</P><P>(ooxml, embedded labels, table is Sheet1)</P><P></P><P>and fails to find the field when I load, e.g.</P><P></P><P>Field not found - &lt;Column</P><P>Heading&gt;</P><P>LOAD [Column</P><P>Heading]</P><P>FROM</P><P>Book1.xlsx</P><P>(ooxml, embedded labels, table is Sheet1)</P><P></P><P>Does anyone know of a workaround that doesn't involve editing the source data file?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 15 Mar 2012 12:01:14 GMT 2012-03-15T12:01:14Z Load from Excel file with embedded labels containing multiple lines https://community.qlik.com/t5/QlikView/Load-from-Excel-file-with-embedded-labels-containing-multiple/m-p/354299#M706436 <HTML><HEAD></HEAD><BODY><P>I'm trying to produce a script to load from an Excel file with embedded labels containing multiple lines, e.g. attached file. </P><P></P><P>The script produced by Table Files button includes carriage return characters within the field name, e.g.</P><P></P><P>LOAD [Column</P><P>Heading]</P><P>FROM</P><P>Book1.xlsx</P><P>(ooxml, embedded labels, table is Sheet1)</P><P></P><P>and fails to find the field when I load, e.g.</P><P></P><P>Field not found - &lt;Column</P><P>Heading&gt;</P><P>LOAD [Column</P><P>Heading]</P><P>FROM</P><P>Book1.xlsx</P><P>(ooxml, embedded labels, table is Sheet1)</P><P></P><P>Does anyone know of a workaround that doesn't involve editing the source data file?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 15 Mar 2012 12:01:14 GMT https://community.qlik.com/t5/QlikView/Load-from-Excel-file-with-embedded-labels-containing-multiple/m-p/354299#M706436 2012-03-15T12:01:14Z Load from Excel file with embedded labels containing multiple lines https://community.qlik.com/t5/QlikView/Load-from-Excel-file-with-embedded-labels-containing-multiple/m-p/354300#M706437 <HTML><HEAD></HEAD><BODY><P> I have qv10 rr4 and have no problems loading from your Excel file.</P></BODY></HTML> Thu, 15 Mar 2012 13:24:16 GMT https://community.qlik.com/t5/QlikView/Load-from-Excel-file-with-embedded-labels-containing-multiple/m-p/354300#M706437 m_woolf 2012-03-15T13:24:16Z Load from Excel file with embedded labels containing multiple lines https://community.qlik.com/t5/QlikView/Load-from-Excel-file-with-embedded-labels-containing-multiple/m-p/354301#M706438 <HTML><HEAD></HEAD><BODY><P> I have QV10 SR1. Guess I need to upgrade again. Thanks, Geoff</P></BODY></HTML> Thu, 15 Mar 2012 13:44:01 GMT https://community.qlik.com/t5/QlikView/Load-from-Excel-file-with-embedded-labels-containing-multiple/m-p/354301#M706438 2012-03-15T13:44:01Z