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.

Generating Pivot Tables

Thread ID:

Created:

Updated:

Platform:

Replies:

103248 Apr 16,2012 06:46 PM Apr 18,2012 12:20 AM ASP.NET Web Forms (Classic) 2
loading
Tags: XlsIO
Craig Beuker
Asked On April 16, 2012 06:46 PM

Greetings all,

I am looking at migrating our pivot table generation from using the Excel Interop to using the XLSIO library. However, we converted one report and promptly ran into an index out of range error (Which doesn't tell us much).

Trying to figure out what was going on exactly, I created a simple little program to re-create the error. The c-sharp code in in the attachments.

Now, If I set the DefaultVersion of the IApplication to ExcelVersion.Excel97to2003, it fail horrifically. If I change the version to Excel2007 or Excel2010, it works without an issue.

Is this:
1) a bug with my sample program. (I can't think that it is given it works with Excel2007/Excel2010
2) a bug with the XLSIO library?
3) a limitation with the XLSIO library?

Thanks in advance for your help.

cmb..


Craig Beuker
Replied On April 16, 2012 06:48 PM

I guess I should actually include the attachment..




Syncfusion.PivotTable.Test_90ca5aa2.zip

Manikandan M [Syncfusion]
Replied On April 18, 2012 12:20 AM

Hi Craig Beuker,

Thank you for using Syncfusion product.

We currently do not provide the support for creating the pivot table for Excel 2003 format. We highly regret for the inconvenience.

For more information,please go through our following online link.

http://help.syncfusion.com/Ug_101/Reporting/XlsIO/ASP.NET/default.htm#!Documents/pivottables.htm

Thanks for your detailed update. Please let us know if you need any clarifications.

Thanks,
Manikandan.M


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.

;