I am currently working with the latest version of Aspose.
I have a requested feature: Could you add some methods to the ListObject class to easily add and remove the rows of a ListObject ?
Excel has this feature: when you right click on a ListObject, you can add and delete rows of the active ListObject. I would like to have this feature with the same behavior than Excel.
If you need further details, do not hesitate to ask.
Thanks in advance for the answer and Many thanks to the Aspose Team for the great job !
No it does not fit my need because if two listobjects are on the same row, the insertRow method will insert row on both listobjects.
What I mainly need is a method to delete a row for a specific listobject, not an entire row. If two listobjects are on the same row, I want to have a method to delete a row for only one listobject without any consequences for the row.
Please download: Aspose.Cells for .NET v126.96.36.199
Please try Cells.InsertRange and Cells.DeleteRange.
Workbook wk = new Workbook(@“D:\FileTemp\Book1.xlsx”);
Aspose.Cells.Tables.ListObject listObject = wk.Worksheets.ListObjects;
CellArea ca = new CellArea();
ca.StartRow = listObject.StartRow + 1;
ca.EndRow = ca.StartRow;
ca.StartColumn = listObject.StartColumn;
ca.EndColumn = listObject.EndColumn;
wk.Worksheets.Cells.DeleteRange(ca.StartRow, ca.StartColumn, ca.EndRow, ca.EndColumn, ShiftType.Up);