IWorksheet.DeleteRow(index)

[Sheila Mullen]

I am currently using an old version of XlsIO dlls (4.102) and was trying to find documentation on the API.

I am trying to delete a row from excel, but when I use IWorksheet.DeleteRow(int index) this appears to clear the row contents rather actually delete the row from the spreadsheet.
Am I using the wrong method to delete the row?

[Lokesh R]

Hi Sheila,

Thank you for your interest on Syncfusion Products.


The statement IWorksheet.DeleteRow(int index,int count)
is actually meant for deleting the rows.

The Delete Row method contains two arguments.

Index-->Position of the row to be deleted

count--->no of rows to be deleted from the mentioned index



since the excel sheet will automatically shifts the contents once the rows get deleted.so, you may feel that its just clearing the contents.

Let me know if you have any queries.

regards,
R.lokesh