insert data into next empty row in excel .xlsx

May 30, 2013 at 1:30 PM
Hi all,

I can successfully get the last used row and column in excel .xlsx. But i have problem where i want to insert data into next unused row (next empty 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, anyone got any idea how to go about this?