Read row

1、 Video example

To be launched.

 

2、 Function description

Read the data of the specified row in the excel file.

 

3、 Attribute description

● Output to variable: the variable assigned to after reading the cell contents.

● workbook objects: a workbook object that is already open.

● Worksheet: the name of the worksheet to read in the workbook. For example, "Sheet1" means to open the first table in the workbook.

● Line number: get the row data of this cell, for example: "A1", get the row data of cell A1.

 

4、 Use example

1. Execution logic

Read excel, line 1 data. Then print it out through the log.

2. Output results