Tag: SPL Desktop Practice

I believe many friends have encountered situations where it is necessary to split a large Excel table into multiple small tables. Obviously, copying and pasting is not advisable, and VBA is too complex. Here is a simpler and more user-friendly method to use esProc SPL, which can help you solve problems in minutes. Let’s directly look at some examples. 1. Split by number of rows Some data of the order table file Orders.xls is shown in the following figure. The first row is the column header, and starting from the second row is the data, with one piece of data