Hi,
Is there any solution to get the last row index used in a Excel worksheet. This is to append some rows in an existing worksheet.
Many thanks
Best regards
Florent.
Hi Florent,
Just handle the EndExport event on the UltraGridExcelExport. The event args will give you the e.CurrentRowIndex.
Hi Mike,
In fact i want to load an existing workseet using Workbook.Load and find the last row used on it.
if (File.Exists(xlsFile)) workBook = Workbook.Load(xlsFile);else workBook = new Workbook();
if (workBook.Worksheets.Exists(worksheetName))worksheet = workBook.Worksheets[worksheetName];
Now i just want to append some rows at the end of the worksheet
i don't know how to find the last row index used in the worksheet.
.