c# Programming, removing rows and sorting problems

[stobi_de]

Hello,
I do not know, how to delete rows or sort a sheet using c#.
I have access to the cells, but something is missing (maybe only in my head )

I tried this
XSpreadsheet oSheet;
XCellRange oCellRange;
oCellRange = oSheet.getCellRangeByPosition(0, i, 255, 1);
oCellRange.Delete () - this or similar is not existing !!

Thanks

frank

[karolus]

Hallo

The quality of answers depends on quality of the question, not on quantity....

Karolus

[RoryOF]

This topic may help
viewtopic.php?f=9&t=2562

[MTP]

If you want to actually remove the rows (and not just clear the contents), you need to obtain the Rows object from the Spreadsheet object, then

Code: Select all

oRows.removeByIndex(i,j)

Where i = The index of the first row to be removed
j = number of rows to remove