How to create a loop for extracting the data from multiple .xlsx files

[madhubabum]

Hi All

I have one Folder with 5 Excel(.xlsx) files

I want to extract the data from excel files with a loop condition.(create a next loop) ?

How can we implement ?

Thanks

Madhu

[alexandros17]

here it is an example:

let path_Pallet = '..\..\*.xlsx';

for each File in filelist (path_Pallet)
PalletInfo:
LOAD * FROM $(File) (ooxml, embedded labels, table is Foglio1);
next File

[#3]

do the files have a consistant naming convention - if they do, you can use a wild card in the file name in the load script

[madhubabum]

Hi Alessandro

If an error occurred , how can we identify ?

Thanks

Madhu

[Colin-Albert]

Enable the document log and look at the log file.