We have an order table file Orders.xls, and part of the data is shown in the figure below. The first row contains the column titles, and the data start from the second row with one piece of data per row.

Now we need to split this file into several small files by the specified number of rows. The split result is shown as follows:

Orders1.xlsx:

Orders2.xlsx:

Orders3.xlsx:

Script:

A1: Read the data of Orders.xlsx file as a cursor, the @c option means reading as a cursor.

A2: Loop through the data in A1, fetching 300 pieces of data each time.

B2: Take Orders + loop sequence number as the file name, and write the data in A2 to the file.

esProc Desktop and Excel Processing
4.26 Aggregate files - insert aggregation sheet
5.2 Split by row - group by data - split into multiple Sheets