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.
