This is a migrated thread and some comments may be shown as answers.

Advanced Grid Exporting to Excel

3 Answers 50 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Brendan Vogt
Top achievements
Rank 1
Brendan Vogt asked on 08 Nov 2010, 01:20 PM
Hi there,

I have basic grid exporting functionality that takes the contents of the grid and exports it to Excel.  I require a little more functionality to this exporting.  Not sure if there is a solution already, but I am hoping that someone has a solution for me.  If my grid has a drop down in it, how do I get this drop drown with its values exported Excel?

Another thing is, is there a way of exporting a business object to Excel?  Lets say I have a Application object, and this object has a Status object which it references.  In my grid I have a list of all the Application objects, but not all the properties of the Application object is used as columns.  How do I get more of the properties exported than what the grid currently displays?

I would appreciate if someone can help me with this :)

Thanks

3 Answers, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 11 Nov 2010, 10:40 PM
Hello Brendan,

I could create a simple demo for the first case if you let me know which format do you use ExcelML or Excel?

Regards,
Daniel
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Brendan Vogt
Top achievements
Rank 1
answered on 12 Nov 2010, 06:17 AM
Thanks.  It would be appreciated.  Would it be possible to get a solution for both?  We are not allowed to use COM components, but they might allow us if I can't get a solution.  Then there is another issue of reading it back in?  Have you maybe got some sample code there?  Reading in rows and cells shouldn't be a problem, but how would I get the value of the selected dropdown?
0
Daniel
Telerik team
answered on 19 Nov 2010, 04:27 PM
Hello Brendan,

Please test the attached project and let me know whether the demonstrated approach is suitable for your scenario.

Best regards,
Daniel
the Telerik team
Browse the vast support resources we have to jumpstart your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
Tags
Grid
Asked by
Brendan Vogt
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Brendan Vogt
Top achievements
Rank 1
Share this question
or