Re: Data Load - Qlik Community

Report Inappropriate Content · ‎2012-07-19

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???

Jason_Michaelides · ‎2012-07-19

This has been asked and answered many times on this forum:

Jason

Report Inappropriate Content · ‎2012-07-19

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??

Jason_Michaelides · ‎2012-07-20

brenner_martina · ‎2012-07-20

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));

Martina

Jason_Michaelides · ‎2012-07-21

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!

brenner_martina · ‎2012-07-23

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

stevedark · ‎2012-09-19

These two threads may be of interest on this subject:

- Steve

Data Load