DeleteRange with Rows

FLX TMS FlexCel for VCL & FMX
1

Hello,


I want to delete Row10 to Row 20 in an Excel-File with xls.DeleteRange. How would this be done?

I was trying to find examples but with no luck.

Sincerely

Peter
2

Hi,

Try with:

    xls.DeleteRange(TXlsCellRange.Create(10, 1, 20, 1), TFlxInsertMode.ShiftRowDown);

Regards,
   Adrian.
3

Hello,


Thank you for the quick reply!

Sincerely

Peter