topic Excel 2007 problem in QlikView

Excel 2007 problem

Wed, 16 May 2012 08:37:58 GMT

I am facing a issue with loading a data from Excel 2007

Please find below the problem statement:-

Every day a file PDMD(Today’sdate).xlsx is generated in

the system with sheet name PDM(today’s day).

For ex. On 16 May 2012 , PDMD16052012 will be generated with

sheetname PDM16

On 17 May 2012 , PDMD17052012 will be generated

with sheetname PDM17.

Now if I load data from each and every excel I will write a

code as below :-

Load *

From

PDMD????????.xls

(ooxml, embedded labels, table is PDMD??);

But unfortunately the above code is not working when the

datasource is Excel 2007 but same is working if datasource

is Excel 2003.

Please suggest .

Excel 2007 problem

RSvebeck — Wed, 16 May 2012 08:47:15 GMT

Is it not just because you must change the extension from .xls to .xlsx ?

Excel 2007 problem

Wed, 16 May 2012 09:14:18 GMT

Hello Robert,

the excels are system generated file..

Reagrds,

Yashpal Singh Rawat

Excel 2007 problem

Anonymous — Wed, 16 May 2012 09:22:59 GMT

Actually robert is almost right. if it is Excel 2007 files, the format is .xlsx, hence it uses

(ooxml, embedded labels, table is PDMD??).

However, if you save as a Excel 2003 file, the format is .xls, hence it uses

(biff, embedded labels, table is PDMD??).

Excel 2007 problem

Wed, 16 May 2012 09:35:26 GMT

Dear all,

the extension is .xlsx sorry it has been written as .xls in the problem statement.

Regards,

Yashpal Singh Rawat

Excel 2007 problem

RSvebeck — Fri, 18 May 2012 13:14:33 GMT

So do you know for sure that this system generated excelfile really is a true XLSX file or could it actually be a XLS file just renamed as a XLSX file?