This project has moved and is read-only. For the latest updates, please go here.

Finding last used row and insert data to the next unused row

May 30, 2013 at 3:28 AM
Hi all,

I can successfully get the last used row and column. But i have the problem where i want to insert data into next unused row.Can anyone guide me about this?
var rowCnt = worksheet.Dimension.End.Row;
                var colCnt = worksheet.Dimension.End.Column;
*This is how i check the last used row/column. So if current last used row is 14, i wish to start insert my datatable start from row 15.