Blazor XLSIO -- Allow add/remove rows to ListObject / Table

Question

I created a feature request for this, but decided to post here also in case there is a workaround that I can use.

I need to modify an existing ListObject (Table) in an Excel file by adding new rows. I can't add a new row to the entire spreadsheet because it contains additional data (not only the ListObject) in the same rows as the where the Table is located.

Example... Columns A through Z have many rows of data and there is a Table in colunmns AB through AG. I need to add new rows ONLY to the table.

I tried to the following, but it doesn't seem to do anything.

IListObject myTable = mySheet.ListObjects[0];

myTable.Location.Resize(5, 6);

Thank you!

Greg

Konduru Keerthi Konduru Ravichandra Raju · Answer

Hi Greg,

We do not have direct support to add or remove rows and columns from table without affecting the outside range.

But we do have a workaround for deleting table rows and columns alone, without affecting the normal range. Please go through the below knowledge base article for code snippet.

https://www.syncfusion.com/kb/12870/how-to-delete-excel-table-rows-and-columns-in-c-vb-net

We are analyzing the workaround for inserting and will share the details with you in 2 business days, on November 10^th, 2023.

Regards,

Keerthi.

Greg Gowin · Answer

Thank you for looking into this Keerthi.  There are a lot of nice features with Excel tables, so we use them quite heavily.  A fix or workaround would be very much appreciated!Thank you!Greg

Konduru Keerthi Konduru Ravichandra Raju · Answer

Greg, the workaround for inserting rows into a table without affecting the normal worksheet range is quite more difficult than we expected. We are still working on it and will get back to you once we find a solution.

Greg Gowin · Answer

Thank you for working on this, it's very much appreciated!Greg

Mohan Chandran · Answer

Greg, we have prepared and attached a sample to achieve your
requirement. We have included workarounds for deleting the table rows and
adding the table rows.Attachment: TableDeleteAdd_9fa83f94.zip