Inserting row, deletes contents of another random row

[ykarapinar]

In the sample code a row is inserted to the excel document (row number 3)
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;