Discussion Board for collaboration on QlikView Scripting.
I have the Excel File which contain the 4 sheets as Ind YTD, Russia YTD ,China YTD, Aus YTD.
what is the best way to load the sheets into qlikview???
The Excel File is going to come every Month, so suppose if sheet name get changed ,say instead of Ind YTD it becomes In Ytd,
Is there any work around ,so that my dependence get rmoved from the sheet names???
This has been asked and answered many times on this forum:
i am not getting the correct link can u please help me with this ????????
or it will be great help if u can send some sample qvw??
you can create a loop like this
For x In Each 'Ind YTD', 'Russ YTD', 'China YTD', Aus YTD'
Load * from Excel.xlsx (ooxml, ..., table is $(x));
Greetings from Munich
Martina - Manish was concerned that the sheet names may change or get added to so a hard-coded solution such as yours won't work.
There are already lots of solutions to this on this forum - just need to research them and adapt the details!
This could help:
set XLS = createobject("Excel.Application")
Set Workbook = XLS.Workbooks.Open(ExcelDoc)
Set Worksheet = XLS.Worksheets(SheetName)
set obj = ActiveDocument.getsheetobject(ChartName)
These two threads may be of interest on this subject: