There are several Pivot Tables throughout this WorkBook.
I've checked the Pivot tables for filter conditions no luck.
Not sure how to proceed since the work book I have will NOT open using XlsIO, but does open in Excel Office 2010.
Any help with this Workbook would be greatly appreciated.
Thanks much.
____________________________________________________________________________________
____________________________________________________________________________________
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 Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotTableParser.ParseFilter(XmlReader reader, PivotTableFilter pivotFilter, PivotValueLableFilter valueFilter)
at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotTableParser.ParseFilters(XmlReader reader, PivotTableImpl pivotTable)
at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotTableParser.ParsePivotTable(XmlReader reader, PivotTableImpl pivotTable)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.ParsePivotTables(IWorksheet sheet, String strParentPath, RelationCollection relations)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.ParsePivotTable(IWorksheet sheet)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParsePivotTables()
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseWorkbook(List`1& themeColors, Boolean parseOnDemand)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseDocument(List`1& themeColors, Boolean parseOnDemand)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseExcel2007Stream(Stream stream, String password, Boolean parseOnDemand)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseStream(Stream stream, String password, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, Stream stream, ExcelParseOptions options, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorkbook(Object parent, Stream stream, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelOpenType openType, String fileName, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String fileName, ExcelOpenType openType, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String fileName, ExcelOpenType openType, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String fileName, ExcelOpenType openType)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String filename)
at ZeddSolutions.XL.XlsIOUtils..ctor(String fileName)