Count number of rows in Excel

Help StudioX
2

Hi @chai01

1.Read Range Workbookactivity
2.rowCount = dataTable.Rows.Count.ToString
3.Build Data Table
Add two columns: "Date", "Row Count"
Output: outputDataTable
4.Add Data Row
ArrayRow: {Now.ToString("dd.MM.yyyy"), rowCount.ToString}
DataTable: outputDataTable
5.Write Range Workbook activity

This image is a flowchart of a UiPath automation sequence that reads data from an Excel file, counts the rows, adds this information along with the current date to a data table, and writes the updated data table back to the Excel file. (Captioned by AI)
This image is a flowchart of a UiPath automation sequence that reads data from an Excel file, counts the rows, adds this information along with the current date to a data table, and writes the updated data table back to the Excel file. (Captioned by AI)818×809 36.9 KB

Regards,