Export data from grid into multiple spread sheets

[Nataraj Vedula]

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

[Pavlina]

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.

[Nataraj Vedula]

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

[Pavlina]

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.

[Nataraj Vedula]

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

[Pavlina]

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.

[Danyal Rashid]

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

[Daniel]

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