Fetch the data from Excel

[sona_sa]

Hi Team,

Need to fetch the data from Excel. Sheet name is Daily Unit Shiftwise KVAH.

Please help me on the same.

Thanks.

[rubenmarin]

Hi, you should store the excel file in a folder where the server has access.

Enter script editor and create a "folder" connection to that folder or a folder above in the estructure. With the connection created click the button to 'select data', follow the dialog to load excel data.

If using data manager select the option to add data, and 'file location', this also creates the folder connection

[sona_sa]

Hi Rubemarin,

Can we do the same with crosstable function, So it would be very helpful - If you share script for the the same.

Thanks.

[PadmaPriya]

Hello @sona_sa 

Please refer to the below articles:

Adding data from Excel and CSV files 

Working with crosstables in the data load script

The CrossTable Load 

Loading-an-excel-spreadsheet-as-a-crosstable

Thanks,

Padma Priya

Qlik Support