topic Re: Data Load in QlikView

Data Load

Thu, 19 Jul 2012 16:48:17 GMT

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

Re: Data Load

Jason_Michaelides — Thu, 19 Jul 2012 17:21:57 GMT

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

http://community.qlik.com/search.jspa?peopleEnabled=true&userID=&containerType=&container=&spotlight=true&q=Load+all+sheets+Excel

Jason

Re: Data Load

Fri, 20 Jul 2012 02:02:44 GMT

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

Re: Data Load

Jason_Michaelides — Fri, 20 Jul 2012 15:47:52 GMT

http://community.qlik.com/search.jspa?resultTypes=&dateRange=all&peopleEnabled=true&q=Load+all+sheets+Excel&containerType=&container=&containerName=&username=

Re: Data Load

brenner_martina — Fri, 20 Jul 2012 15:52:08 GMT

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

Greetings from Munich

Martina

Re: Data Load

Jason_Michaelides — Sat, 21 Jul 2012 12:23:43 GMT

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!

Re: Data Load

brenner_martina — Mon, 23 Jul 2012 07:12:22 GMT

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

Re: Data Load

stevedark — Wed, 19 Sep 2012 08:13:47 GMT

These two threads may be of interest on this subject:

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

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

- Steve