Formatting Exports from Telerik RadGrid (PDF,Word, Excel)

Hello Ken,

We appreciate your taking the time to submit the code-library. As a sign of gratitude for your efforts, we updated your Telerik points.

Best regards,
the Telerik team

Hi,
I have tried several suggestions, from this topic as well, to export custom formatting however still no CSS style is applied on the exported file.  I have tried formatting on Item Created and Data Bound, however the export will the following settings still doesn't format my excel file.  I am also adding custom labels in each cell and would like these values to be printed depending on what is actually visible on the grid (i use CSS to hide and show label within a cell).  If label1 is visible then i want that to be printed in exported report and if label2 is visible then i would need that value (one is percentage, and one is actual count).

aspx file:

 

<

 

telerik:RadGrid ID="ViewerGrid" runat="server" ShowHeader="true" ShowFooter="true"

 

 

CssClass="ViewerGridStyle" OnItemDataBound="Grid_DataBound" EnableEmbeddedSkins="false"

 

 

Skin="360Theme">

 

 

<ExportSettings IgnorePaging="true">

 

 

<Excel FileExtension="xls" />

 

 

<Csv ColumnDelimiter="Comma" RowDelimiter="NewLine" />

 

 

</ExportSettings>

 

 

<MasterTableView ShowHeadersWhenNoRecords="true">

 

 

</MasterTableView>

 

 

</telerik:RadGrid>

code behind on click event of button:
grid.ExportSettings.Excel.Format = GridExcelExportFormat.Html;
grid.ExportSettings.ExportOnlyData = false;
grid.ExportSettings.HideStructureColumns = true;
grid.MasterTableView.ExportToExcel();

Your help in this matter is greatly appreciated.  I am a bit hesitant to install Office for these operations as Microsoft discourages it. 

thanks,

 

I am unable to Download the grid into pdf .Please help me    

<telerik:RadGrid ID="grd" runat="server"  Width="100%"  AllowSorting="true"
                    Skin="Office2007" BorderWidth="2px" BorderColor=" Silver " PageSize="15"
                    AllowPaging= "true" GridLines="Both" AutoGenerateColumns="False"
                    onpageindexchanged="grdTransactions_PageIndexChanged"
                    onpagesizechanged="grdTransactions_PageSizeChanged" OnItemCreated="grdTransactions_ItemCreated" OnItemCommand="grdTransactions_ItemCommand">
                    <PagerStyle Mode="NextPrevAndNumeric" />
                    <ExportSettings IgnorePaging="true" OpenInNewWindow="true">
            <Pdf PageHeight="210mm" PageWidth="297mm" PageTitle="SushiBar menu" DefaultFontFamily="Arial Unicode MS"
                PageBottomMargin="20mm" PageTopMargin="20mm" PageLeftMargin="20mm" PageRightMargin="20mm">
            </Pdf>
        </ExportSettings>
                    <ItemStyle Height="40px" VerticalAlign="Middle" HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" Font-Size="12px" Font-Bold="true" />
                    <AlternatingItemStyle Height="40px" VerticalAlign="Middle" HorizontalAlign="Center" />
                    <MasterTableView TableLayout="Auto" DataKeyNames="TransactionID">
             
                        <Columns>
                            <telerik:GridBoundColumn DataField="TransactionID" HeaderText="TransactionID" UniqueName="TransactionID" Visible="false"/>
                           
                            <telerik:GridBoundColumn DataField="DebitAmount" HeaderText="Debit Amount" HeaderStyle-Width="10%" UniqueName="DebitAmount"/>
                            <telerik:GridBoundColumn DataField="CreditAmount" HeaderText="Credit Amount" HeaderStyle-Width="10%" UniqueName="CreditAmount" />
                        </Columns>
                    </MasterTableView>
                </telerik:RadGrid>

 <br />
               <asp:Button ID="DownloadPDF" runat="server" Width="100%" CommandName="ExportToPdf" Text="DownloadToPdf" OnClick="BtnDownloadPDF"
          ></asp:Button>



and in .cs file

  public void BtnDownloadPDF(object sender,EventArgs e)
    {
        bool isExport = false;
        isExport = true;
        grdTransactions.ClientSettings.Scrolling.UseStaticHeaders = false;
        grdTransactions.MasterTableView.ExportToPdf();
   

Dear Team,

I found static class FormatingRadGridExports,everything working file for download first time.Filter in Radgrid after not able to download any file format ,its apply css format in HTML page.Also PDF file download but format was not well ,its over right on one another. 

Please find attached ,rar for your reference.