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 Feb 01, 2017 2:39 pm

Hi,

I'm trying to create an empty sheet and then add new row with data but I get an exception while trying to access cell. I didn't find any example with the creation of an empty sheet and then adding new row.

Here is my code:

Code: Select all
var workbook = new Spire.Xls.Workbook();

Worksheet worksheet = workbook.CreateEmptySheet("NewSheet");

worksheet.InsertRow(1);

row.Columns[0].Value = "New Value";


What I'm doing wrong?

Thanks

mystcreater
 
Posts: 18
Joined: Tue Sep 29, 2015 12:10 am

Thu Feb 02, 2017 4:54 am

Hello,

Thanks for your feedback. I have noticed the issue and posted it to our Dev team, once it is resolved, or we have some other update, we will let you know ASAP.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Tue Feb 28, 2017 3:31 am

Hello,

Glad to inform you that the issue has get resolved in the latest hotfix(Spire.XLS Pack Hotfix Version:7.11.59), please upgrade to it and have a try.
Please contact us if you have any questions.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Return to Spire.XLS