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.

Thu Nov 14, 2013 9:12 am

We are glad to announce a new hotfix version of Spire.XLS for bug solutions. Spire.XLS 7.1.24 is available today as a download. Our develop team focus on fixing bugs in this version. Details are as followed:
Bug Solutions:

Fixed the error "Value cannot be NULL. Parameter name: root" while loading xlsm file.
Fixed the error "The given key was not present in the dictionary" while saving excel file.

Welcome to experience Spire.XLS 7.1.24 with downloading here:

http://www.e-iceblue.com/Download/downl ... t-now.html
User avatar

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

Sun Jan 19, 2014 2:07 pm

I experience the same issue with a newer version 7.2.3.7040 when loading XSLM file (attached)

I have downloaded the DLL from here:
your site Download download-excel-for-net-now.html

I am using the .NET 4.0 version of it.

Here is my code:
var workbook = new Workbook();
workbook.LoadFromFile(path);

Exception:
{"Value cannot be null.\r\nParameter name: root"}

Callstack:

at sprᝓ..ctor(sprᮠ A_0, String A_1)
at sprᝓ..ctor(sprᮠ A_0)
at sprṞ.ᜀ(Stream A_0)
at sprṞ..ctor(Stream A_0)
at sprử.ᜁ(Stream A_0)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.ᜀ(Stream A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.ᜀ(String A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(sprᶦ A_0, Object A_1, String A_2, ExcelParseOptions A_3, Boolean A_4, String A_5, ExcelVersion A_6)
at sprử.ᜀ(Object A_0, String A_1, ExcelParseOptions A_2, Boolean A_3, String A_4, ExcelVersion A_5)
at sprḝ.ᜀ(String A_0, ExcelParseOptions A_1, Boolean A_2, String A_3, ExcelVersion A_4)
at Spire.Xls.Workbook.LoadFromFile(String fileName, ExcelVersion version)
at Spire.Xls.Workbook.LoadFromFile(String fileName)

borismod
 
Posts: 1
Joined: Sun Jan 19, 2014 1:40 pm

Mon Jan 20, 2014 1:37 am

Hello,

Thanks for your inquiry.
Sorry that we didn't received your Xlsm file, could you please send it to our Email(support@e-iceblue.com) again?
Thanks,
Gary
E-iceblue support team
User avatar

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

Sun Apr 03, 2016 2:57 am

Hi,
I still get the exact error loading a very simple Excel file. I am using the PDF Converter "Free Spire.PDFConverter for .NET Component is a Community Edition"

The code is as simple as it could be:

[TestMethod]
public void ConvertExcelToPdf_Locally_ThrowAwayTest()
{
try
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:\Temp\PercentCalculations.xlsx");
workbook.SaveToFile(@"C:\Temp\PercentCalculations.Pdf");
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}

The error is: ""Value cannot be NULL. Parameter name: root""

The Excel file is also attached.

Any help will be appreciated.

thx
Attachments
PercentCalculations.rar
File to test with
(7.12 KiB) Downloaded 263 times

rahman.mahmoodi@gmail.com
 
Posts: 1
Joined: Thu Mar 24, 2016 10:17 am

Mon Apr 04, 2016 5:09 am

Hi,

Thanks for your posting.
PDFConverter just is a simple tool and does not provide API for program to produce PDF files.
Please use the latest Spire.Xls, Spire.XLS Pack Hotfix Version:7.9.39 .
Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:\Temp\PercentCalculations.xlsx");
workbook.SaveToFile(@"C:\Temp\PercentCalculations.Pdf",Spire.Xls.FileFormat.PDF);


Best Regards,
Amy
E-iceblue support team
User avatar

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

Wed Apr 06, 2016 6:46 am

Hi,

Has your issue been resolved?
Thanks for your feedback in advance.

Best Regards,
Amy
E-iceblue support team
User avatar

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

Return to Spire.XLS