Everything worked brilliantly, until this week when we tried to update the template in Excel 2016. We made a minor change to the spreadsheet and now receive the exception below.
I validated the updated Excel file with the Microsoft Open XML SDK and no errors were found.
Any help would be greatly appreciated.
- Code: Select all
System.Xml.XmlException was unhandled
HResult=-2146232000
LineNumber=0
LinePosition=0
Message=Unexpected xml tag.
Source=Spire.XLS
StackTrace:
at spr4315.1(XmlReader A_0, XlsShape A_1, RelationsCollection A_2, String A_3, spr262 A_4, List`1 A_5, Dictionary`2 A_6)
at spr4315.2(XmlReader A_0, XlsShape A_1, RelationsCollection A_2, String A_3, spr262 A_4, List`1 A_5, Dictionary`2 A_6)
at spr4315.0(XmlReader A_0, XlsWorksheetBase A_1, String A_2, List`1 A_3, Dictionary`2 A_4)
at spr4315.1(XmlReader A_0, XlsWorksheetBase A_1, String A_2, List`1 A_3, Dictionary`2 A_4)
at spr4315.4(XmlReader A_0, XlsWorksheetBase A_1, String A_2, List`1 A_3, Dictionary`2 A_4)
at spr511.0(XlsWorksheetBase A_0, spr5002 A_1, Dictionary`2 A_2)
at spr511.0(XlsWorksheetBase A_0, String A_1, Dictionary`2 A_2)
at spr4315.0(XmlReader A_0, XlsWorksheet A_1, Dictionary`2 A_2)
at spr4315.0(XmlReader A_0, XlsWorksheet A_1, MemoryStream& A_2, String A_3, Dictionary`2 A_4)
at spr4315.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 spr511.1(XlsWorksheet A_0, Dictionary`2 A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
at spr4315.0(Dictionary`2 A_0)
at spr262.0(List`1& A_0)
at spr262.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.0(String A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(spr2469 A_0, Object A_1, String A_2, ExcelParseOptions A_3, Boolean A_4, String A_5, ExcelVersion A_6)
at spr846.0(Object A_0, String A_1, ExcelParseOptions A_2, Boolean A_3, String A_4, ExcelVersion A_5)
at spr995.0(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)
at OpenXmlValidation.Program.Main(String[] args) in C:\Dev\OpenXmlValidation\OpenXmlValidation\Program.cs:line 31
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException: