Iterate through each sheet and get the total rows in same excel

Help Studio
,
1

I need to iterate through all the sheet using “for each sheet” activity however am not able to then understand how do I take count of total rows as “CurrentSheet.RowsCount” is not working.

2

Hi @A-Ui ,

Could you check with the below :

CurrentSheet.DataTableValue.RowCount
3

@A-Ui

use this

sheetDataTable.Rows.Count

4

Assign throws an exception
“assign: exception has been thrown by the target of an invocation”.

5

Can’t find sheetDataTable in this “for each sheet” activity

6

@A-Ui ,

Could you show us the Implementation done and if possible the Excel sheet data (Or just the count of rows present) ?

Implementation from our End :

image
image582×509 23.7 KB

7

Tried the same workflow still that exception was thrown. Sorry couldn’t share the sheet.
My excel has 25, 63, 44 and 48 rows in respective sheet.

8

@A-Ui

you are not able to find the For Each Sheet activity right

can you once upgrade or downgrade the system.activities version and check

9

Didn’t work, tried both upgrade and downgrade. Tho any specific version you would recommend?

10

@A-Ui ,

We still do not have a confirmation on your workflow implementation and the Error, Is it possible to share screenshot of the workflow done till now (No need of Input Excel)?

11

@A-Ui

can you tell the version you are using ?

or
can you share the screenshot of the activity which you have used

for the expression CurrentSheet.DatatableValue.rowscount

12

Screenshot_20231018-112033_Outlook
Screenshot_20231018-112033_Outlook1080×1111 84.1 KB

Here is a screenshot of the workflow

13

I tried Read range from classic and then output the data into datatable.
Used dt.rows.count to display - works under “for each sheet” activity

14

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