This is a migrated thread and some comments may be shown as answers.
Export data from grid into multiple spread sheets
7 Answers 134 Views
This is a migrated thread and some comments may be shown as answers.
Nataraj Vedula
Top achievements
Rank 1
Nataraj Vedula asked on 04 May 2009, 03:37 PM
Hi,

I have exported the rad grid data into excel format using the below LOC
ReportGrid.ExportSettings.IgnorePaging = true;  
            ReportGrid.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.Html;  
            ReportGrid.ExportSettings.ExportOnlyData = true;  
            this.ReportGrid.MasterTableView.ExportToExcel(); 

Now requirement is to add a policy statement in another spread sheet of the excel report that was generated. How can i achieve this using the rad grid properties?
Right now data source bound to the rad grid does not contain information related to the policy statement . It has to be either explicitely referred or include that in the data source.

Telerik guidence will be extremely helpful for me to solve these issue.

Thanks,
Nataraj

7 Answers, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 05 May 2009, 10:16 AM
Hi Nataraj,

Exporting the RadGrid content to multiple Excel sheets is not supported and I am not sure whether such type of export is attainable. Can you please direct us to online resources on this subject or another web grid on the market which supports the requested export mechanism? Thus we will be able to research the matter further and eventually consider it for future implementation.

Thank you for your cooperation.

Sincerely yours,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Nataraj Vedula
Top achievements
Rank 1
answered on 07 May 2009, 05:27 AM

Hi Pavlina,

Though i was disappointed to hear that telerik does not support this feature, thanks for your reply.
And i have not seen this kind of feature in any other toolkit. Because i have used Telerik already, i just want to know whether Telerik supports this feature or not.

I need some more help from Telerik. Because i cannot display the policy statement in another spreadsheet, the other option that i have in hand is, I have to display a link to this policy statement in the RAD grid footer .Is it possible to add a link in the Grid footer, which in turn calls the policy statement content?

Below is the way i defined my Grid:

<telerik:RadGrid Height="99%" ID="ReportGrid" runat="server" GridLines="None"    
Skin="Web20" Visible="False" AllowSorting="True" OnNeedDataSource="ReportGrid_NeedDataSource"    
ShowGroupPanel="True" Font-Names="Calibri" Font-Size="Smaller" AllowPaging="True"    
PagerStyle-Mode="NextPrevNumericAndAdvanced" PagerStyle-AlwaysVisible="true"    
PageSize="14" EnableAjaxSkinRendering="true">     
<MasterTableView>    
      <RowIndicatorColumn>    
      <HeaderStyle Width="20px" />    
      </RowIndicatorColumn>    
<ExpandCollapseColumn>    
 <HeaderStyle Width="20px" />    
</ExpandCollapseColumn>    
</MasterTableView>    
<ClientSettings AllowDragToGroup="True" ClientMessages-DragToGroupOrReorder="Drag to group">     
<Scrolling AllowScroll="True" />    
</ClientSettings>    
<PagerStyle Mode="NextPrevNumericAndAdvanced" />    
<FilterMenu EnableTheming="True" Skin="Web20">     
<CollapseAnimation Duration="200" Type="OutQuint" />    
</FilterMenu>    
</telerik:RadGrid>   

The grid data is bound during tthe runtime from using datasource. I need to provide the link in the grid footer which opens the another model window.

Telerik guidence will be extremely helpful for me to solve these issue.

Thanks,
Nataraj
0
Pavlina
Telerik team
answered on 11 May 2009, 03:25 PM

Hi Natterjack,

You could display a link to the policy statement in the RAD grid footer. I suggest that you handle the ItemCreated event to insert the link in the grid footer.

Sincerely yours,

Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Nataraj Vedula
Top achievements
Rank 1
answered on 11 May 2009, 03:37 PM
Can you send me a piece of code to achieve this based on the my grid definition. I have tried some options but of no success.
Basically i am not clear on how to access Grid footer to add an link programatically.
I even tried to add this to my pager template programatically. but then my pager was gone. I could not see page numbers nothing. Just the link that i have added.

Please help me out in achieving this.

Thanks,
Nataraj
0
Pavlina
Telerik team
answered on 12 May 2009, 03:22 PM
Hi Nataraj,

I am sending you a small runnable application which handles the desired functionality. Give it a try and see if it works for you or if I am leaving something out.

Sincerely yours,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Danyal Rashid
Top achievements
Rank 1
answered on 25 Nov 2010, 10:36 PM
In response to
"Exporting the RadGrid content to multiple Excel sheets is not supported and I am not sure whether such type of export is attainable"

Farpoint (v2005) supports multiple sheets.

Thanks
0
Daniel
Telerik team
answered on 25 Nov 2010, 10:50 PM
Hello Danyal,

The following code-library project demonstrates how to export data to more than one worksheet.
Multiple worksheets in ExcelML

I also recommend that you examine the following links:
ExcelML basics
ExcelML structure / GridExcelBuilder

Let us know if you need further assistance.

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
Nataraj Vedula
Top achievements
Rank 1
Answers by
Pavlina
Telerik team
Nataraj Vedula
Top achievements
Rank 1
Danyal Rashid
Top achievements
Rank 1
Daniel
Telerik team
Share this question
or