Write in column

1、 Video example

To be launched.

 

2、 Function description

Write a set of data to the specified column in the excel file, and write the values and formulas supported by Excel.

 

3、 Attribute description

● workbook objects: the excel workbook object variable that has been opened.

● worksheet: the name of a table in the Workbook: for example: "Sheet1".

● column name: the name of the column to be written. For example: & ldquo; A” Indicates that a value or formula is written in column a.

● starting line: the starting position of the column to be written.

● data: a group of data, wrapped in square brackets. Each column of data is separated by commas, for example: [1,2, & lsquo; three & lsquo;], indicating that 1 is written at A1, 2 is written at B1, and 3 is written at C1.

● is it saved: whether to save the file after writing.

 

4、 Use example

1. Execution logic

Open excel and write a column of data to column D of Excel.

2. Output results