topic Fetch the data from Excel in App Development

Fetch the data from Excel

sona_sa — Sat, 29 May 2021 04:23:45 GMT

Hi Team,

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

Please help me on the same.

Thanks.

Re: Fetch the data from Excel

rubenmarin — Sat, 29 May 2021 06:50:41 GMT

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

Re: Fetch the data from Excel

sona_sa — Sat, 29 May 2021 07:23:53 GMT

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.

Re: Fetch the data from Excel

PadmaPriya — Sat, 29 May 2021 09:57:25 GMT

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