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

How to check for the last row of excel
Macro to insert row in excel based on criteria ✓ - Forum - Excel
How to duplicate rows in excel multiple times ✓ - Forum - Excel
Macro to insert row based on variable cell value (text) - Forum - Excel
Repeat multiple rows in excel - Guide
Duplicate rows in excel based on cell value ✓ - Forum - Excel

1 reply

Answer 1 / 1

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.

Subscribe To Our Newsletter!