Row Number in each Sheet

CloverDX Platform
1

Hi,

I have a need to get the row number of the sheet(s) in Excel File. Autofilling - global_row_count,sheet_row_count and metadata_row_count are not reset for each sheet. Is there a variable to get the rownumber in the sheet?

I am thinking to check the sheetname change and reset a global variable. If there is a better way, please let me know.

Thanks very much for your support.

2

Hello,
there is no auto-filling function for for the requested value. Your solution is proper.