Method TXlsWorkSheet.DeleteRows does not work

[marius]

Hello Lars,

I stumbled on a other problem, the DeleteRows does not seem to work.

You can reuse the sample i send to you, just replace the (only) line in the TfrmMain.btnCopyClick with this.
XLS[0].InsertRows(10, 5);
XLS[0].InsertRows(10, 5);
XLS[0].DeleteRows(10, 5);
XLS[0].DeleteRows(10, 5);

Regards,
Marius

[larsa]

Hello

The second parameter of DeleteRows is not a number of rows, it's a row number.
The correct code for your sample is:

Code: Select all

XLS[0].InsertRows(10, 5);
XLS[0].InsertRows(10, 5);
XLS[0].DeleteRows(10, 14);
XLS[0].DeleteRows(10, 14);

[marius]

Whoops, I automaticly assumed the same parameters, its not as consistent as i thought

Sorry for the disturbance
Marius