Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Alessandro
If an error occurred , how can we identify ?
Thanks
Madhu
Enable the document log and look at the log file.