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.

Sun Sep 18, 2016 5:51 pm

I am getting the following exception when I try to load an Excel file that has a macros.

System.NullReferenceException was unhandled
Message: An unhandled exception of type 'System.NullReferenceException' occurred in Spire.XLS.dll
Additional information: Object reference not set to an instance of an object.


System.Transactions Critical: 0 : <Description>Unhandled exception</Description><AppDomain>PwC.Confirm.ProcessorHost.vshost.exe</AppDomain><Exception><ExceptionType>System.NullReferenceException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType><Message>Object reference not set to an instance of an object.</Message><StackTrace> at spr8640.1(XlsWorksheet A_0, Dictionary`2 A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
at Spire.Xls.Core.Spreadsheet.XlsWorksheetBase.ParseData()
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.40()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.ClearAll()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.DisposeAll()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean SaveChanges, String Filename)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean saveChanges)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Finalize()</StackTrace><ExceptionString>System.NullReferenceException: Object reference not set to an instance of an object.
at spr8640.1(XlsWorksheet A_0, Dictionary`2 A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
at Spire.Xls.Core.Spreadsheet.XlsWorksheetBase.ParseData()
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.40()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.ClearAll()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.DisposeAll()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean SaveChanges, String Filename)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean saveChanges)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Finalize()</ExceptionString></Exception></TraceRecord>

The code is as follows (where artifact.Stream) is a Stream object. Exception occurs on the LoadFromStream method:
Code: Select all
var workbook = new Workbook();
                    workbook.LoadFromStream(artifactStream.Stream);
                    using (var excelStream = new MemoryStream())
                    {
                        workbook.SaveToStream(excelStream, Spire.Xls.FileFormat.PDF);
                        AppendPdf(mergedPdf, new PdfDocument(excelStream));
                    }

fletch407
 
Posts: 4
Joined: Sun Sep 18, 2016 5:43 pm

Mon Sep 19, 2016 8:50 am

Hi,

Thanks for your inquiry. Could you provide your document for looking into the issue?

Sincerely,
Alan
E-iceblue support team
User avatar

Alan.Li
 
Posts: 35
Joined: Mon Sep 05, 2016 2:51 am

Mon Sep 19, 2016 1:38 pm

See attached.
Attachments
Macros.zip
(18.92 KiB) Downloaded 257 times

fletch407
 
Posts: 4
Joined: Sun Sep 18, 2016 5:43 pm

Tue Sep 20, 2016 3:05 am

Hi,

Thanks for your feedback. I have noticed this issue and posted it to our Dev Team. Once it resolved, l will inform you. Sorry for inconvenience.

Sincerely,
Alan
E-iceblue support team
User avatar

Alan.Li
 
Posts: 35
Joined: Mon Sep 05, 2016 2:51 am

Fri Nov 11, 2016 8:23 am

Hi,

Thanks for waiting.
Now the issue has been resolved in Spire.Office Platinum Version:2.15, welcome to test it.

Sincerely,
Betsy
E-iceblue support team
User avatar

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

Wed Nov 16, 2016 5:36 pm

Thanks so much for the fix. We have, however, encountered another issue. The stack trace is below and the Excel sheet is attached.

Requested value 'auto' was not found.

at System.Enum.EnumResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument)
at System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
at Spire.Xls.Core.Spreadsheet.XmlSerialization.Charts.ChartParser.1(XmlReader A_0, IChartSerieDataFormat A_1, spr2727 A_2)
at Spire.Xls.Core.Spreadsheet.XmlSerialization.Charts.ChartParser.2(XmlReader A_0, XlsChartSerie A_1, RelationsCollection A_2)
at Spire.Xls.Core.Spreadsheet.XmlSerialization.Charts.ChartParser.1(XmlReader A_0, XlsChart A_1, ExcelChartType A_2, RelationsCollection A_3, spr2727 A_4)
at Spire.Xls.Core.Spreadsheet.XmlSerialization.Charts.ChartParser.1(XmlReader A_0, XlsChart A_1, RelationsCollection A_2, Dictionary`2 A_3, spr2727 A_4)
at Spire.Xls.Core.Spreadsheet.XmlSerialization.Charts.ChartParser.1(XmlReader A_0, XlsChart A_1, RelationsCollection A_2, spr2727 A_3)
at Spire.Xls.Core.Spreadsheet.XmlSerialization.Charts.ChartParser.2(XmlReader A_0, XlsChart A_1, RelationsCollection A_2, spr2727 A_3)
at Spire.Xls.Core.Spreadsheet.XmlSerialization.Charts.ChartParser.1(XmlReader A_0, XlsChart A_1, RelationsCollection A_2)
at Spire.Xls.Core.Spreadsheet.XmlSerialization.Charts.ChartParser.ParseChart(XmlReader reader, XlsChart chart, RelationsCollection relations)
at spr2727.0(XmlReader A_0, XlsChart A_1, RelationsCollection A_2, spr7691 A_3, String A_4)
at spr2727.0(MemoryStream A_0, XlsWorksheetBase A_1, String A_2)
at spr2727.1(XmlReader A_0, XlsWorksheetBase A_1, String A_2, List`1 A_3, Dictionary`2 A_4)
at spr2727.4(XmlReader A_0, XlsWorksheetBase A_1, String A_2, List`1 A_3, Dictionary`2 A_4)
at spr8707.0(XlsWorksheetBase A_0, spr6633 A_1, Dictionary`2 A_2)
at spr8707.0(XlsWorksheetBase A_0, String A_1, Dictionary`2 A_2)
at spr2727.0(XmlReader A_0, XlsWorksheet A_1, Dictionary`2 A_2)
at spr2727.0(XmlReader A_0, XlsWorksheet A_1, MemoryStream& A_2, String A_3, Dictionary`2 A_4)
at spr2727.0(XmlReader A_0, XlsWorksheet A_1, String A_2, MemoryStream& A_3, MemoryStream& A_4, List`1 A_5, Dictionary`2 A_6, Dictionary`2 A_7)
at spr8707.1(XlsWorksheet A_0, Dictionary`2 A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
at spr2727.0(Dictionary`2 A_0)
at spr7691.0(List`1& A_0)
at spr7691.1(List`1& A_0)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(Stream A_0, String A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(Stream A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(spr1941 A_0, Object A_1, Stream A_2, ExcelParseOptions A_3, ExcelVersion A_4)
at spr553.0(Object A_0, Stream A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at spr5631.0(Object A_0, Stream A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at spr8315.0(Stream A_0, ExcelVersion A_1, ExcelParseOptions A_2)
at spr8315.0(Stream A_0, ExcelVersion A_1)
at spr8315.0(Stream A_0)
at Spire.Xls.Workbook.LoadFromStream(Stream stream)

fletch407
 
Posts: 4
Joined: Sun Sep 18, 2016 5:43 pm

Thu Nov 17, 2016 1:59 am

Dear fletch407,

Thanks for the feedback and sorry that there is another issue.
And I didn't find the attached file, could you please upload it again ? Or you can send it to us(support@e-iceblue.com) via email.

Thanks,
Betsy
E-iceblue support team
User avatar

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

Thu Nov 17, 2016 2:25 pm

Sorry Betsy, here is the attachment.
Attachments
BadExcelSheet.zip
(93.01 KiB) Downloaded 244 times

fletch407
 
Posts: 4
Joined: Sun Sep 18, 2016 5:43 pm

Fri Nov 18, 2016 1:54 am

Dear fletch407,

Thanks for the file.
I have reproduced the issue and posted it to our Dev team. We will inform you when it is fixed.
Sorry for inconvenience.

Sincerely,
Betsy
E-iceblue support team
User avatar

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

Wed Jan 25, 2017 6:20 am

Dear fletch407,

Thanks for waiting.
Now the issue has resolved in Spire.Office Platinum (Hot Fix) Version:2.15.4, welcome to test it.
Looking forward to your feedback.

Sincerely,
Betsy
E-iceblue support team
User avatar

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

Return to Spire.XLS