Excel content loop

1、 Video example

To be launched.

 

2、 Component description

Cycle the rows, columns or ranges of Excel.

 

3、 Attribute description

● the contents of the cycle are stored in the: saves the contents of the loop in a variable.

● the current line number is saved in the: saves the line number of the current loop in a variable.

● Circulation area: you can choose to cycle by row, column, region, or edited region.

● workbook objects: the excel document object to be cycled. The excel document object can be & ldquo; Create a new excel & rdquo; Or & ldquo; Open excel & rdquo; Output to variable in these two components.

● worksheet: the name of the table that will loop.

● starting cell line number: the starting line number of the loop.

● starting cell column name: the starting column name of the loop.

 

4、 Use example

1. Execution logic

Open excel, cycle through the edited range, and then output the data of each row.

2. Output results

Excel data

Console results