I'm using Aspose.Cells (22.214.171.124) to modify an existing workbook (Book1.xlsx). I created a simple range (first column, first 4 rows) and wrote a snippet of code to insert a row within this range. Then its saved to a new workbook (Book2.xlsx).
After opening the new workbook, I noticed the range now extends to the end of the workbook in rows. (The number of columns remained the same).
Please see the attached Visual Studio 2010 Console Application. It does the following:
- Opens Book1.xlsx
- Gets a ref to the Sheet1
- Inserts a row
- Saves Book1.xlsx as Book2.xlsx
When I open Book2.xlsx, I see that Range1 extends to the end of the workbook in rows.
I appreciate any feedback.