Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
psankepalli
Partner - Creator III
Partner - Creator III

Load excel 2013 Cell into Qlikview

     Hello Experts,

I would like to load Date value form Excel 2013 Sheet1 into Qlikview.

I am using the following code, its failing because this code is useful for 2010 excel format.

Any idea what are the Column names for Excel 2013 ?

LOAD //[Arrival Time],

          E, // E Field

Date(Date#(SubField(E,':',2),'MM/DD/YYYY'),'YYYYMMDD') as WeekEndingDate

       // Date(Date#(SubField(E,':',2),'YYYYMMDD')) as WeekEndingDate

FROM

(ooxml, embedded labels, table is Sheet1);

//Where RecNo() >1 and RecNo() <5;

The above code is working fine with Excel 2010, but not with 2013.

its not identifying value of E when loading Excel 2013.

Please Help!

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

I can read your spreadsheet straight into QlikView with this without any transformations whatsoever - all dates are handled automatically:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD [Arrival Time],

     [End Time],

     C,

     D,

     E

FROM

(ooxml, embedded labels, table is Sheet1);

View solution in original post

2 Replies
petter
Partner - Champion III
Partner - Champion III

I can read your spreadsheet straight into QlikView with this without any transformations whatsoever - all dates are handled automatically:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD [Arrival Time],

     [End Time],

     C,

     D,

     E

FROM

(ooxml, embedded labels, table is Sheet1);

psankepalli
Partner - Creator III
Partner - Creator III
Author

Thank you for your help..