I want to print the number of rows present in Excel (this is a dynamic number) and with that row count. I do not want the header being included. This is what I tried until now:
Asked
Active
Viewed 80 times
0
-
1If you want to ignore the header in your count, can't you just do records - 1? – InbetweenWeekends May 29 '20 at 13:59
-
Yes, it works if I change the code to : "var records = Sheet.rowCount-1; console.log("Total Records:" + records)" Thanks! – nick Jun 01 '20 at 06:18