Read area

1、 Video example

To be launched.

 

2、 Function description

Read the contents of the specified range in the excel file.

 

3、 Attribute description

● output to: 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.

● cell area: an area in the worksheet: for example, "A1: B2" means to obtain the contents of areas A1 to B2.

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

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

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

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

 

4、 Use example

1. Execution logic

Read excel, rows 1 to 2, columns a to B. Then print it out through the log.

2. Output results