Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
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,
then ?????
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:
Jason
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??
Hi,
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));
Next
Greetings from Munich
Martina
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:
function SheetIt(ExcelDoc,SheetName,ChartName,Category)
set XLS = createobject("Excel.Application")
false
False
Set Workbook = XLS.Workbooks.Open(ExcelDoc)
Set Worksheet = XLS.Worksheets(SheetName)
set obj = ActiveDocument.getsheetobject(ChartName)
true
select
false
end function
Greetings
Martina
These two threads may be of interest on this subject:
http://community.qlik.com/message/258952
http://community.qlik.com/message/258414
- Steve