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.

Fri Sep 13, 2019 10:21 am

I've used free spire.xls ver9.2.1 Well....
Now I have a problem when insert datatable to excel.

-. My original value is "0+", "1+", "2+", "0-", "1-", "2-",......
-. Excel value is "0", "1", "2", "0", "-1", "-2",......

I checked DataTable cell value is correct.
My code is "sheet.InsertDataTable(ToBeDataTable, false, 3, 1);"

Thanks....

kebby70
 
Posts: 7
Joined: Tue Jun 26, 2018 4:31 pm

Mon Sep 16, 2019 8:46 am

Hi,

Thanks for your inquiry and sorry to reply late for weekend.
I tested your case with Spire.XLS Pack(Hotfix) Version:9.9.5 but didn’t reproduce your issue. Firstly, I suggest you try to use the latest version of Spire.XLS which has more improvements than free versions.
If the issue still exists, to help us investigate it accurately, please offer us your input DataTable as well as the complete code you were using which could reproduce your issue directly. You could upload them here or send us(support@e-iceblue.com) via email.

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Wed Oct 30, 2019 9:49 am

Hi,

Greetings from E-iceblue.
How's your issue going? Could you please give us some feedback at your convenience?

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Tue Feb 18, 2020 11:52 pm

too late reply.

I've solved by below code.
sheet.InsertDataTable(ToBeDataTable, false, fisrtRow, firstColumn, maxRow, maxColumn, true);

kebby70
 
Posts: 7
Joined: Tue Jun 26, 2018 4:31 pm

Wed Feb 19, 2020 1:40 am

Hi,

Thanks for your feedback.
Any question, please feel free to contact us.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS

cron