...

Filter Data by Location

 

Example

Part of the data in the Excel file book1.xlsx is shown in the figure below:

..

Now we want to select the even-numbered rows in the table, as shown in the following figure:

..

Write SPL script:

A

1

=T("E:/work/book1.xlsx")

2

=A1.select(#%2==0)

3

=T("E:/work/book2.xlsx",A2)

 

A1 Read the data in book1.xlsx as a table sequence

 

A2 Select the data of even-numbered rows in A1, and # represents the current row number in the select loop

 

A3 Store the table sequence in A2 to book2.xlsx

 


 
 •  228 View  •