When you say that there will be a new sheet every month do mean a new sheet (tab) will be added to this Excel file or will there be a new file for the month?
If there is going to be a new file every month then it's very easy. If all the columns are identical for each month then put all the files into one folder. It's good practice to add the path to this folder to the script as a variable:
LET vxlsFolder = 'insert path here ';
(biff, embedded labels, table is Orders$);
table is Orders$ here means that the script will extract from a sheet called Orders like you have in the file you uploaded.
Save your files to your folder and create your script to read one of them. When it's working then edit the line
replacing the filename with '*'.
The script will then concatenate all the lines from the files into a single table Order.
In that case I'll refer you to this: Load Multiple excel sheets using For loop
S there is an update only once a month the simpler thing may be to make separate files from each sheet.
Tried , Iam getting error, Kindly check once
LET vStartSheetNumber = 1;
LET vEndSheetNumber = 50;
LET vExcelFileName = 'Data';
// Generate Empty table
'' AS Sno,
'' AS Name,
'' as [Sales Value]
FOR index = vStartSheetNumber TO vEndSheetNumber
(ooxml, embedded labels, table is [Page $(index)]);
ODBC CONNECT TO [Excel Files;DBQ=$(vXLSPath)];
for i = 0 to FieldValueCount('TABLE_NAME') -1
Let vTablename = Left(Peek('TABLE_NAME',$(i)),len(Peek('TABLE_NAME',$(i)))-1);
(ooxml, embedded labels, table is [$(vTablename)]);
DROP Table Sheets;