We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

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

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)

1 Reply

SR Sudha Ramachandran Syncfusion Team October 2, 2015 08:20 AM UTC

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


Loader.
Live Chat Icon For mobile
Up arrow icon