PDA

View Full Version : Component or solution to export a filtered grid to an excel



ISCFernando
Mar 30, 2016, 7:41 PM
Hi.

I have been checking the ext.net product and i found it is very useful and complete. Before I proceed to acquire a license, I´d like to know if there is a component or solution to export a filtered grid to an excel file. Or if you have a component you can recommend can work along with ext.net.

It is important to mention I had been using Telerik product, and its grid has the option for exporting to xls, pdf,doc, etc. At this moment a new client is requesting a solution with ext.net but the great issue I have is the grid doesn’t have an exporting options.

Any comments are welcomed.

Thanks for your time.

fabricio.murta
Mar 31, 2016, 1:53 AM
Hello @ISCFernando! Welcome to Ext.NET forums!

Maybe this is what you want: Export data from GridPanel (http://examples4.ext.net/#/GridPanel/Miscellaneous/Export_Data_Ajax/).

This uses Ext.NET only, no third-party libraries.

Alternatively there are also solutions using the Microsoft Office Interop API to export grids to MS-Excel and charts to MS-Powerpoint presentations.

Here are two MS articles related to office interop:
- How to: Access Office Interop Objects by using Visual C# features (https://msdn.microsoft.com/en-us/library/dd264733.aspx)
- Walkthrough: Office Programming (C# and Visual Basic) (https://msdn.microsoft.com/en-us/library/ee342218.aspx)

MS-Office interop is not related to Ext.NET (third-party) but it scales very well with Ext.NET grids and charts.

I hope this helps!