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

RadGridView exporting to excel and pdf

34 Answers 798 Views

GridView

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

34 Answers, 1 is accepted

answered on 15 May 2009, 09:06 AM

untitled.png

Hi lin,

I just tried our demo however the exporting worked fine - screenshot attached.

Can you provide more info about your browser?

Sincerely yours,
Vlad
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.

answered on 21 May 2009, 08:12 AM

my code here!

Uri uri = new Uri(HtmlPage.Document.DocumentUri, String.Format("SanofiApplicationTestPage.aspx?type={0}", extension));

WebClient client = new WebClient();

client.UploadStringCompleted +=

new UploadStringCompletedEventHandler(client_UploadStringCompleted);

client.UploadStringAsync(uri,content);

void client_UploadStringCompleted(object sender, UploadStringCompletedEventArgs e)
        {
            HtmlPage.Window.Navigate(new Uri(HtmlPage.Document.DocumentUri, String.Format("Export.{0}", extension)), "_blank");
        }

i use mytestpage name aspx instead of ExportHandler.aspx
can i use?
i think so!
Requested URL: /Export.xls

help me urgent!pls

thanks

Accepted

answered on 21 May 2009, 09:17 AM

Hi lin,

Here is the relevant code for export file saving:

        protected void Page_Load(object sender, EventArgs e)
        {
            string path = Server.MapPath(String.Format("~/Export.{0}", Request.QueryString["type"]));

            if (File.Exists(path))
            {
                File.Delete(path);
            }

            using (FileStream fs = File.Create(path))
            {
                using (StreamReader sr = new StreamReader(Request.InputStream))
                {
                    Byte[] info = System.Text.Encoding.Default.GetBytes(sr.ReadToEnd());
                    fs.Write(info, 0, info.Length);
                }
            }
        }

You need to add this in your page.

Regards,
Vlad
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.

answered on 22 May 2009, 01:44 AM

hi

actually following code is inside mysilverlight control xaml cs file

Uri uri = new Uri(HtmlPage.Document.DocumentUri, String.Format("SanofiApplicationTestPage.aspx?type={0}", extension));

WebClient client = new WebClient();

//client.Headers[HttpRequestHeader.ContentType] = "application/vnd.ms-excel";

client.UploadStringCompleted +=

new UploadStringCompletedEventHandler(client_UploadStringCompleted);

client.UploadStringAsync(uri,content);

}

void client_UploadStringCompleted(object sender, UploadStringCompletedEventArgs e)

{

HtmlPage.Window.Navigate(new Uri(HtmlPage.Document.DocumentUri, String.Format("Export.{0}", extension)), "_blank");

}

this following code is inside myapptname.aspx page!
protected void Page_Load(object sender, EventArgs e)
        {
            string path = Server.MapPath(String.Format("~/Export.{0}", Request.QueryString["type"]));

            if (File.Exists(path))
            {
                File.Delete(path);
            }

            using (FileStream fs = File.Create(path))
            {
                using (StreamReader sr = new StreamReader(Request.InputStream))
                {
                    Byte[] info = System.Text.Encoding.Default.GetBytes(sr.ReadToEnd());
                    fs.Write(info, 0, info.Length);
                }
            }
        }

but! show the error message "Failed to map the path '/Export'."
so! how can i do that!

thanks

answered on 22 May 2009, 06:16 AM

Hi Lin,

I am also facing the same problem. Can you please help me in exporting the grid.

Here is my code:

Uri

uri = new Uri(HtmlPage.Document.DocumentUri, String.Format("ExportHandler.aspx?type={0}", extension));

WebClient client = new WebClient();

client.UploadStringCompleted +=

new UploadStringCompletedEventHandler(client_UploadStringCompleted);

client.UploadStringAsync(uri, content);

void client_UploadStringCompleted(object sender, UploadStringCompletedEventArgs e)

{

HtmlPage.Window.Navigate(new Uri(HtmlPage.Document.DocumentUri, String.Format("Export.{0}", extension)), "_blank");

}

Ahead of you for your response.

Regards
Satish

answered on 22 May 2009, 06:37 AM

silverlightapplication3.zip

Hello,

I've attached an example project demonstrating how to export RadGridView to Excel.

Kind regards,
Vlad
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.

answered on 04 Nov 2009, 06:20 PM

Vlad,
Once I save my .xls file and i try to open it shows a warning message.
"The file you are trying to open, 'name.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before oepning the file. Do you want to open the file now?"

I press yes and it looks fine but why am I getting that warning message?
My code looks like...

    
                    private void btnExportToExcel_Click(object sender, RoutedEventArgs e)  
        
                    {  
        
                        Uri uri = new Uri(HtmlPage.Document.DocumentUri, string.Format("ExportReport.aspx?Name={0}", uxSectionTitle.Text));  
        
                        WebClient client = new WebClient();  
        
                        client.UploadStringCompleted += new UploadStringCompletedEventHandler(client_UploadStringCompleted);  
        
                        client.UploadStringAsync(uri, uxKPIDetails.ToHtml(true));  
        
                    }  
        
                    void client_UploadStringCompleted(object sender, UploadStringCompletedEventArgs e)  
        
                    {  
        
                        Uri uri = new Uri(HtmlPage.Document.DocumentUri, string.Format("{0}.xls", uxSectionTitle.Text));  
        
                        HtmlPage.Window.Navigate(uri);  
        
                    }

And in my ExportReport.aspx

    
            protected void Page_Load(object sender, EventArgs e)  
        
                    {  
        
                        if (Request.QueryString["Name"] != null)  
        
                        {  
        
                            string fileName = Request.QueryString["Name"].ToString();  
        
                            string path = Server.MapPath(fileName + ".xls");  
        
                            if (File.Exists(path))  
        
                            {  
        
                                File.Delete(path);  
        
                            }  
        
                            using (StreamReader sr = new StreamReader(Request.InputStream, Encoding.UTF8))  
        
                            {  
        
                                StreamWriter sw = new StreamWriter(path);  
        
                                sw.Write(sr.ReadToEnd());  
        
                                sw.Close();  
        
                                sr.Close();  
        
                            }                  
        
                        }  
        
                    }

Thanks,

answered on 23 Mar 2010, 11:18 AM

Hello Vlad,

When I run the application I get an InvalidOperationException: Access is denied...
Do you know what the problem is?

StackTrace:
   at System.Windows.Browser.ScriptObject.Invoke(String name, Object[] args)
   at System.Windows.Browser.HtmlWindow.Navigate(Uri navigateToUri, String target, String targetFeatures)
   at System.Windows.Browser.HtmlWindow.Navigate(Uri navigateToUri, String target)
   at SilverlightApplication3.Page.client_UploadStringCompleted(Object sender, UploadStringCompletedEventArgs e)
   at System.Net.WebClient.OnUploadStringCompleted(UploadStringCompletedEventArgs e)
   at System.Net.WebClient.UploadStringOperationCompleted(Object arg)

Thanks and regards,
Kristof

answered on 23 Mar 2010, 11:45 AM

export.png

Hello Vlad,

In the demo you use an Export method

    
            If dialog.ShowDialog() = True Then 
        
                        Using stream As Stream = dialog.OpenFile()  
        
                            grdMCPOverview.Export(stream, New GridViewExportOptions())  
        
                        End Using  
        
                    End If

But I can't use that method because Export is not a member of Telerik.Windows.Controls.RadGridView.
I use the version 2009.3.1103.1030 of the dll's.

Is there an other way to do it...

Thanks and regards,
Kristof

answered on 03 Feb 2015, 11:48 AM

212610---TreeListViewSpreadProcessing-SL5-NoXAML.zip

Hello Prithvi,

A possible way to fulfill your requirement is to follow our SpreadProcessing/RadGridViewIntegration online demo, which provides a way to decide what will be written on each row in the excel or pdf file.

I attached an updated version of the demo that prints only the parent rows in TreeListView.

I hope this help.

Regards,
Boris
Telerik

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

RadGridView exporting to excel and pdf

34 Answers, 1 is accepted

Server Error in '/' Application.

The resource cannot be found.

hi i test alreday with my proj. but still got error! because my proj http is http://localhost/mytestingpage.aspx following error..... The resource cannot be found.

The resource cannot be found.

hi

i test alreday with my proj. but still got error! because my proj http is http://localhost/mytestingpage.aspx
following error.....

The resource cannot be found.