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

Export to pdf and save programmatically

20 Answers 1065 Views

Grid

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

20 Answers, 1 is accepted

Accepted

answered on 03 Apr 2009, 11:31 AM

Hello Anto,

Have a look at the following code-snippet:

    
            <asp:Button ID="Button1" runat="server" Text="Save on server" />  
        
            <telerik:RadGrid ID="RadGrid1" runat="server" Skin="Vista" Width="500px">  
        
              <ExportSettings ExportOnlyData="true" />  
        
            </telerik:RadGrid>

    
            Public Partial Class _Default  
        
                Inherits System.Web.UI.Page  
        
                Private url As String, path As String = ""  
        
                Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load  
        
                    url = [String].Format("~/{0}.pdf", RadGrid1.ExportSettings.FileName)  
        
                    path = Server.MapPath(url)  
        
                End Sub  
        
                Protected Sub RadGrid1_NeedDataSource(source As Object, e As GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource  
        
                    Dim table As New DataTable()  
        
                    table.Columns.Add("ID", GetType(Integer))  
        
                    table.Columns.Add("Name", GetType(String))  
        
                    table.Rows.Add(1, "Michael")  
        
                    table.Rows.Add(2, "George")  
        
                    RadGrid1.DataSource = table  
        
                End Sub  
        
                Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click  
        
                    RadGrid1.MasterTableView.ExportToPdf()  
        
                End Sub  
        
                Protected Sub RadGrid1_GridExporting(source As Object, e As GridExportingArgs) Handles RadGrid1.GridExporting  
        
                    If File.Exists(path) Then  
        
                        'DELETE THE FILE IF ALREADY EXISTS  
        
                        File.Delete(path)  
        
                    End If  
        
                    Using fs As FileStream = File.Create(path)  
        
                        Dim info As [Byte]() = System.Text.Encoding.[Default].GetBytes(e.ExportOutput)  
        
                            'SAVE IT ON THE SERVER  
        
                        fs.Write(info, 0, info.Length)  
        
                    End Using  
        
                    Response.Redirect("~/Default.aspx")  
        
                End Sub  
        
            End Class

Regards,
Daniel
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

Accepted

answered on 13 Jun 2014, 09:51 AM

hi daniel
i want to export radgrid in hierarchy
and i dont want to use onneeddatasource
i bind datasource to radgrid in buttonclick event

code:
gridname.ExportSettings.FileName = "filename";
gridname.ExportSettings.ExportOnlyData = true;
gridname.ExportSettings.IgnorePaging = true;
gridname.ExportSettings.OpenInNewWindow = true;
gridname.MasterTableView.UseAllDataFields = true;
gridname.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML;
gridname.MasterTableView.HierarchyDefaultExpanded = true;
gridname.MasterTableView.DetailTables[0].HierarchyDefaultExpanded = true;
gridname.MasterTableView.HierarchyLoadMode = GridChildLoadMode.Client;
gridname.MasterTableView.DetailTables[0].HierarchyLoadMode = GridChildLoadMode.Client;
gridname.MasterTableView.ExportToExcel();

when i dont use onneeddatasource for grid it give me object reference is not set error

answered on 31 May 2016, 03:30 PM

Hello,

I am not getting below DLL for .net 3.5 version. Can you help me where I will get it.

Imports Telerik.Windows.Documents.Spreadsheet.FormatProviders
Imports Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx
Imports Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf
Imports Telerik.Windows.Documents.Spreadsheet.FormatProviders.TextBased.Csv
Imports Telerik.Windows.Documents.Spreadsheet.FormatProviders.TextBased.Txt
Imports Telerik.Windows.Documents.Spreadsheet.Model

answered on 08 Nov 2016, 09:01 AM

Hello,

Straight onto your questions.

As I understand from you - this is a limitation of Telerik "Save exporting file" mechanism, should It be fixed in next version? (this is very important)
I'm afraid this can't be fixed. The built-in export functionality is designed to stream the output to the response. There are multiple changes made during the ASP.NET lifecycle which are irreversible.

I am looking for an event that happened AFTER the Xslx file exported (in order to display alert - the RadWindowManager does not show alert if I write it in the GridExporting event).
There is no such event. If you want to be notified when the file is ready then you may use a cookie as shown here.
Show loading panel when exporting RadGrid

I'd like to note that none of these are supported out of the box.

Regards,
Daniel
Telerik by Progress

Check out the new UI for ASP.NET Core, the most complete UI suite for ASP.NET Core development on the market, with 60+ tried-and-tested widgets, based on Kendo UI.