Previous Topic Next Topic

How to check for the last row of excel

Closed
new_c# Posts 1 Registration date Saturday December 18, 2010 Status Member Last seen December 17, 2010 - Dec 17, 2010 at 11:11 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 04:19 PM
hi,

i am writing data from csv file to excel using c#, by data contains more that 80000 rows, so i want to check the end of the excel file i.e the last row(655536) and if it reaches the last row then create a new sheet and write rest of the data to it.

hope to get the solution here
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2011 at 04:19 PM
if you are writing to excel line by line , you would need to keep a counter

if you importing file, then I am inclined to say that what you seek is not possible.