Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Nov 07, 2012 4:24 pm

Hello i am using spire.XLS 6.9 and I was hoping that someone could help point me in the right direction while trying to add new columns and rows to a new worksheet. Currently I am trying the workbook.worksheets[0].InsertColumn(1) and workbook.worksheets[0].InsertRows(1) methods but they do not seem to add anything at all. I ran into a similar problem while trying to add a column to the end of an existing worksheet (workbook.worksheets[0].InsertColumn(5)). Any help is appreciated.

ClickPointSoftware
 
Posts: 1
Joined: Thu Oct 18, 2012 2:56 am

Thu Nov 08, 2012 3:16 am

Hi ClickPointSoftware,

Thanks for your inquiry.
We have done some tests, but we don't reproduce your problems. We use code1 to add a new row and a new column to a worksheet of a xlsx file, and use code2 to add a new column to the end of a worksheet of a xlsx file. We attach some sreenshots of original xlsx file and the result xlsx files. If we miss something, please tell us.
code1:
Code: Select all
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("original.xlsx");
            Worksheet worksheet=workbook.Worksheets[0];
            worksheet.InsertRow(1);
            worksheet.InsertColumn(1);
            workbook.SaveToFile("addNewRowAndNewColumn.xlsx", ExcelVersion.Version2007);


code2:
Code: Select all
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("original.xlsx");
            Worksheet worksheet=workbook.Worksheets[0];
            worksheet.InsertColumn(5);
            workbook.SaveToFile("addNewColumnToTheEnd.xlsx", ExcelVersion.Version2007);


Best regards,
Amy
E-iceblue support
Attachments
addNewColumnToTheEnd.PNG
addNewColumnToTheEnd.PNG (4.02 KiB) Viewed 4014 times
addNewRowAndNewColumn.PNG
addNewRowAndNewColumn.PNG (4.09 KiB) Viewed 4014 times
original.PNG
original.PNG (3.89 KiB) Viewed 4014 times
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS