Failure to open an Excel Spread Sheet with the following Error.

[Ethol Palmer]

There are several Pivot Tables throughout this WorkBook.  

The Specific Error: System.ArgumentException ... Requested value 'dateBetween' was not found.

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.

____________________________________________________________________________________

Stack Trace

____________________________________________________________________________________

   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)

[Sudha Ramachandran]

Hi Ethnol,

 

We were able to reproduce the problem. A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates

 

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

 

Please let me know if you have any questions.

 

Thanks,

Sudha R