Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Data Load

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

7 Replies
jason_michaelid
Honored Contributor II

Re: Data Load

Not applicable

Re: Data Load

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

brenner_martina
Valued Contributor II

Re: Data Load

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

jason_michaelid
Honored Contributor II

Re: Data Load

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
Valued Contributor II

Re: Data Load

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

MVP
MVP

Re: Data Load

These two threads may be of interest on this subject:

http://community.qlik.com/message/258952

http://community.qlik.com/message/258414

- Steve

Community Browser