Read cell

1、 Video example

To be launched.

 

2、 Function description

Read the contents of the specified cell in the open excel file and output the contents to the specified variable in the form of string.

 

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 in the workbook.

● line number: read the row of the cell. Example: read & ldquo; A1” The line number is & ldquo; 1”。

● column name: read the column in which the cell is located. Example: read & ldquo; A1” The column name is & ldquo; A”。

 

4、 Use example

1. Execution logic

Open an excel and read the contents of column a in the first row of Excel cells.

2. Output results