How to pick the data from excel with multiple sheet.

[lalitkgehlot89]

Hi,

In current scenario I have three excel file in folder with named Text, Text_2, Text_3. Each file has some Date wise Sheet.

Files in folder and Sheets in File are not fixed. I want to load the data automatically form these file.

I tried to right the logic but getting some error. Please help me to right the logic asap.

[nishanthi_8]

This will load all the files under the specified folder:

for each File in Filepath("C:\Users\Desktop\*.xlsx")

Table1:

load

*

From "C:\Users\Desktop\*.xlsx";

NEXT File

[lalitkgehlot89]

Hi Rajendran,

I have multiple sheets in each file. And no of sheets are also not fixed.

In this case it is not working.

[nishanthi_8]

So the date in excel sheets will be on continuous basis or it can be discrete ?

[lalitkgehlot89]

It can be discreate.

[trdandamudi]

Hope the below link will help:

Load multiple excel files from Multiple excel sheetsinto QV