Read column

1、 Video example

To be added.

 

2、 Function description

Read the data of the specified column 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.

● column name: get the column data of the cell, for example: "A1", get the column data of cell A1.

 

4、 Use example

1. Execution logic

Read excel, column a data. Then print it out through the log.

2. Output results