Count number of rows in Excel

Help StudioX
1

Hi,

I need some help how I can count the number of rows in an excel and output for that day to another Excel sheet

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,

3

Hi,

Thanks for your help. I looked at the screenshot and I will only need the bot to read the number of rows in excel file and extract only the total number in another excel sheet

4

@chai01

This image depicts a process flow in which data is read from "Sheet1" of "Excel1.xlsx", the row count is calculated and stored in a variable called rowCount, and this row count is then written to cell "A2" of "Sheet2" in the same workbook. (Captioned by AI)
This image depicts a process flow in which data is read from "Sheet1" of "Excel1.xlsx", the row count is calculated and stored in a variable called rowCount, and this row count is then written to cell "A2" of "Sheet2" in the same workbook. (Captioned by AI)596×504 16 KB

Regards,

5

I am having trouble sending a screenshot of the workflow :frowning:

for assign i wrote down “dataTable.Rows.Count.ToString” in value to save but facing the error “reference to a non-shared member requires an object reference”

6

@chai01

dataTable is the output of Read Range Workbook activity did you assigned correctly please check it once

Regards,

7

i made the change now getting an error "option strict on disallows implicit conversions from string to integer

8

@chai01

image

rowCount = dataTable.Rows.Count.ToString

image
image1050×72 2.98 KB

Regards,

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.