Retrieve Excel worksheets in correct sequence

Wed, 24 Mar 2010 18:01:56 GMT

Hello all,

I am trying to retrieve the worksheets from an .xls in the order that they are defined in the workbook but they only seem to return in alphabetical sequence.

I have used the connection strings for jet/odbc/excel driver:

CONNECT TO [Provider=Microsoft.Jet.OLEDB.4.0;Data Source='$(vFile)';Extended Properties="Excel 8.0;"];
ODBC CONNECT TO [Excel Files;DBQ=$(vFile)];
CONNECT TO [Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls)};DBQ=$(vFile)];

but still no success.

I realise that this is more related to Excel than Qlikview but as many out there are doing some good things with Qlikview/Excel the answer may already be to hand. I have not been able to google any solution.

Any help much appreciated.

Regards,

Gordon

topic Retrieve Excel worksheets in correct sequence in QlikView

Retrieve Excel worksheets in correct sequence