When the code is executed, it deletes the contents of row number 3840
Sample Excel file can be downloaded from the link;
http://www.avinal.net/xlsrw.rar
Code: Select all
XLSReadWriteII51.FileName:='C:\XLSRW.xlsx';
XLSReadWriteII51.Read;
XLSReadWriteII51[0].InsertRows(2, 1);
XLSReadWriteII51.Write;