Count number of rows in an excel using studioX

I need to count the total number of rows in an excel using STUDIOX.
I have done this multiple times in studio but I cannot find any similar activity in STUDIOX.
Please help!!!

Hi,

How about Find/First/Last DataRow activity as the following?

Regards,

1 Like

Hi,

Thanks for providing the solution. This is working for me but for my process, the excel file keeps on changing, so is the name of the sheet. Is there any workaround for this?

Thanks

Hi,

How do you identify target file or sheet?
If there is single target file or single target sheet in folder or workbook, the following will work, for example.

Regards,

This worked :slight_smile:

Thanks a lot !!

1 Like

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