topic Re: Loading Data from Specific sheets in Excel in App Development

Loading Data from Specific sheets in Excel

psenthilbtech — Mon, 11 Jun 2018 15:39:59 GMT

Hi Team,

I have a requirement where i need to read the data from a specific excel file.

Exa:

The Excel file has 4 Sheets

1.Sol

2. Data for Field1

3. Data for Field2

4.Data for Field 3

The Requirement is i need to pull all the data from the sheets which has the names starting with Data for Field.

Need your input on this. Attaching you the sample excel file

Regards,

Senthil

brunobertels — Mon, 11 Jun 2018 15:56:28 GMT

See this post

you may find the way to achieve your requierment

psenthilbtech — Mon, 11 Jun 2018 16:07:45 GMT

Hi Bruno,

Thanks .

But in my scenario, it should read the data only from specific sheets. Any input on how to achieve this

brunobertels — Mon, 11 Jun 2018 16:35:49 GMT

So my be this post from omar bensalem will help you

isingh30 — Mon, 11 Jun 2018 17:44:24 GMT

Main Script - Table Files - Select your file - Excel format - Table - Drop down(Contains all the tabs of the sheet)

You can select the file from the drop down.

kaanerisen — Mon, 11 Jun 2018 18:59:46 GMT

Hi Senthil,

MasterTable:

LOAD *

FROM

[lib://Directory/International.xlsx]

(ooxml, embedded labels, table is [Data for Field*]);

This will get all data table in sheets which name starts with "Data or Field"

Hope it helps.