We have existing code that exports a report to Excel and creates a pivot table on the Excel Worksheet in VB6. I need to do the same thing in .Net using the infragistics controls. How can I do this using infragistics.excel? Is it supported? Would I have to export the Worksheet and get Excel to do the Pivot table itself?
Thanks
Rachel Blunden
Pivot tables are currently not supported in 12.2. I have forwarded this post to the Developer Support Manager to create a feature request on your behalf.
Hello Rachel,
I have sent your product idea directly to our product management team. Our product team chooses new product ideas for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development, you will be notified at that time. Your reference number for this product idea is PI12120104.
Thank you for your request.
Is there a way of doing pivots yet
Is pivot table still supported in infragistics excel export ?
currently i use infragistics excel to load excel file and then export it but i lose
pivot tables already exists in the excel file .
is pivot table supported in infragistics WPF (if so i can try using that for excel export) ?
Pivot tables are still not supported fully in the Excel library. You can add a feature request for this here: http://ideas.infragistics.com/forums/192359-windows-forms However, we do have round-trip support for pivot tables and slicers now in the 2007 and later formats. So you can load an existing file as a template which already contains the pivot table, add data to it, and then save it out to a different location.