Inserting row, deletes contents of another random row
Posted: Wed Dec 10, 2014 2:13 pm
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
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;