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.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

120669 Oct 1,2015 06:51 PM Oct 2,2015 04:20 AM Windows Forms 1
loading
Tags: XlsIO
Ethol Palmer
Asked On October 1, 2015 06:51 PM

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 [Syncfusion]
Replied On October 2, 2015 04:20 AM

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;