topic loading all sheets from single excel file in QlikView

loading all sheets from single excel file

Wed, 07 Apr 2010 11:34:59 GMT

Hi,

I want to load all sheets from Excel files and store .csv files in a seperate folder.The naming convention should be the First three charactors of the excel file followed by the sheet name.

Say for example, there is a excel file FIN_SCH_Revenue.It contains 10 sheets(tables).

I want to store all the sheets as .csv files with the naming convention like FIN_sheet1.csv..

How to write script for this?

Thanks,

Buvana

loading all sheets from single excel file

spsrk_84 — Wed, 07 Apr 2010 12:13:40 GMT

Hi,

In QlikView there are few built functions like $filepath,filename use those functions and as you need the first three letters only use LEFT function with a condition like LEFT($filename,3)

Regards,

Ajay

loading all sheets from single excel file

Wed, 07 Apr 2010 12:27:21 GMT

Hi Ajay,

I am new to Qlikview.Can you explain in detail?I am aware of those fns.can you explain little bit.

Thanks