1. 首页
  2. 文档
  3. Write cell

白皮书下载

实在智能Agent产品白皮书(7.2.0).pdf

Write cell

发刊日期:
2021/10/15

编辑团队:
实在学院

1、 Video example

To be launched.

 

2、 Function description

Write data to specified cells in Excel file, and write values and formulas supported by Excel.

 

3、 Attribute description

Workbook object: an excel workbook object variable that has been opened.

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

● Line number: the row number of the target cell to write.

● column name: the column name of the target cell to write to.

● data: the data to be written in the cell: for example, "2021" or "sum (A2: A9)" means to fill the sum of cells A2 to A9 into cell A1.

● Save: whether to save the file.

 

4、 Use example

1. Execution logic

Open excel and write a paragraph of text to row 3 and column a in Sheet1 of Excel.

 

2. Output results

企业培训
技术支持
加入社群
公众号
实在智能Agent学习群
扫码关注微信公众号