Count total number of column values

Help Activities
, ,
1

I am having one excel file in which there are 25 sheets.In every sheets there are 12 rows and 6 columns.So the total number is 72 and in excel file it has 1800 columns has data.how to do it?
TIA

2

Hi @Cuberoot

Can you try the below

image
image900×1305 54.6 KB

Count_Rows=Excel.Sheet(CurrentSheet.Name).DataTableValue.RowCount
Count_Columns=Excel.Sheet(CurrentSheet.Name).DataTableValue.Columns.Count
Total=Total+(Count_Rows*Count_Columns)

Cheers!!

3

Hi @Cuberoot

Regards

4

I want how to calcuate total number of columns.if their is one sheet and their is data in 72 cells.then how to do it in UiPath.above shows total rows in one sheet.
image

5

Can’t we do it in excel application scope?

6

@Cuberoot

How about the following?

image
image900×1144 45.4 KB

Count_Rows=DataTable.RowCount
Count_Columns=DataTable.ColumnCount
Total=Total+(Count_Rows*Count_Columns)
7

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