# Row Number in each Sheet

**URL:** <https://forum.cloverdx.com/t/row-number-in-each-sheet/688>\
**Category:** CloverDX Platform\
**Created:** [March 27, 2010, 12:00am UTC](https://forum.cloverdx.com/t/row-number-in-each-sheet/688 "2010-03-27T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mkutti](https://avatars.discourse-cdn.com/v4/letter/m/a88e4f/32.png) [@mkutti](https://forum.cloverdx.com/u/mkutti)\
**Post date:** [March 27, 2010, 12:00am UTC](https://forum.cloverdx.com/t/row-number-in-each-sheet/688/1 "2010-03-27T00:00:00Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [March 29, 2010, 8:44am UTC](https://forum.cloverdx.com/t/row-number-in-each-sheet/688/2 "2010-03-29T08:44:50Z")

</div>

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