Monday, 28 March 2016

Total Rows in Excel

Native Excel in DELPHI

Workbook:= TXLSWorkbook.Create();
Workbook.open('d:\temp\');
Workbook.Sheet[1].Name:= 'Sheet1';

MaxRow:= Workbook.ActiveSheet.UsedRange.Rows.Count;