白皮书下载
实在智能Agent产品白皮书(7.2.0).pdf
clear area
发刊日期：
2021/10/15
编辑团队：
实在学院
1、 Video example
To be launched.
2、 Function description
Clears a specified range in the excel file.
3、 Attribute description
●Workbook object: the excel workbook object variable that has been opened.
●Worksheet: the name of a table in the Workbook: for example: "Sheet1".
●region: an area to be cleared, for example & ldquo; A1: B2 "indicates that the area value from A1 to B2 is cleared and becomes blank.
●Clear format: Yes means that the text and format are cleared together; no means that only the text is cleared.
●Save: whether to save after clearing.
4、 Use example
1. Execution logic
Open excel and clear the contents of the specified area.
2. Output results
Original data
Post execution data
