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
4479
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

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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.
0