白皮书下载
实在智能Agent产品白皮书(7.2.0).pdf
Number of rows read
发刊日期:
2021/10/15
编辑团队:
实在学院
1、 Video example
2、 Function description
Read the total number of rows in the specified excel document (the number of rows with data in the last row).
3、 Attribute description
● Output to variable: used to save the number of rows returned.
● Workbook object: select the specified excel document. It supports manual input and selection from the variable library.
● Worksheet: select the specific worksheet to be operated in the specified excel document.

4、 Use example
1. Execution logic
In this example, go through & ldquo; Open excel & rdquo; Component open the test.xlsx file on the desktop, & ldquo; Read rows & rdquo; Component is used to read the total number of rows in the file, and finally output the variable that saves the number of rows.

2. Output results
Return the selected excel document test.xslx. The total number of rows is 18.





