Export to excel problem in https site in UI for ASP.NET AJAX Grid

sudheer

109 posts

Member since:
Dec 2008

Posted 23 Apr 2009 Link to this post

Hi telerik team,

while exporting telerik grid to excel, i m getting internet explorer can't download Filename from the sitename alert box is coming if prefix contains https://. but for http:// it's exporting fine , hope i need to configure some setting in IE browser please give those steps.

Thanks for any help.

Shinu

17764 posts

Member since:
Mar 2007

Posted 23 Apr 2009 Link to this post

Hi Sudheer,

Please refer the following forum link which discusses similar scenario. Hope the solution provided in the forum will helpful to you.
ExportToExcel fails when using HTTPS

You can also try the approach, suggested in the end of the following document:
Known reasons for error messages

-Shinu

sudheer

109 posts

Member since:
Dec 2008

Posted 23 Apr 2009 Link to this post

Hi shinu ,

I tried with all those steps mentioned in that URL .but i couldn't acheive can u see the below URL for image
http://picasaweb.google.com/lh/photo/HBvJr5kwNWfDyP5xdujNVw?feat=directlink

and code which i followed is
void excel()
{

GrdAudit.Page.Response.ClearHeaders() ;

GrdAudit.Page.Response.Cache.SetCacheability(

HttpCacheability.Private);

GrdAudit.MasterTableView.ExportToExcel();
}

Pavlina

Admin

6187 posts

Posted 27 Apr 2009 Link to this post

Hello Sudheer,

I followed your scenario in my attempt to replicate the issue but to no avail. At this point in order to progress in the resolution of this matter it will be best if you open a formal support ticket and send me a small project which would allow me to track the issue locally. Thus I could do all my best to help you further in solving it.

Best regards,
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.

sudheer

109 posts

Member since:
Dec 2008

Posted 27 Apr 2009 Link to this post

Hi pavlina,

Thanks for reply anyway .I resolved that issue the problem due to

When Internet Explorer communicates with a secure Web site through SSL, Internet Explorer enforces any no-cache request. If the header or headers are present, Internet Explorer does not cache the file. Consequently, Office cannot open the file.

so shouldn't allow below line of code .

Response.CacheControl = "no-cache";

------No need to use below lines------

GrdAudit.Page.Response.ClearHeaders() ;

GrdAudit.Page.Response.Cache.SetCacheability(HttpCacheability.Private);

Ashwini Kumar Varma Bhupathiraju

1 posts

Member since:
Aug 2009

Posted 07 Aug 2009 Link to this post

Hi Guys,

I tried all king of things in my Code but no luck for me.

My Code looks like this.

DataTable ExcelTable = (DataTable)Session[AppConstants.SK_EXCEL_TABLE];

string attachment = "inline; filename= "+ AppConstants.EXCEL_FILE_NAME +".xls";

//Response.CacheControl = "no-cache";

Response.Clear();

Response.Buffer = true;

Response.ContentType = "application/vnd.ms-excel";

Response.AddHeader("content-disposition", attachment);

Response.Charset = "";

this.EnableViewState = false;

Response.Write(this.getHTMLTable(ExcelTable));

Response.Flush();

Session.Remove(AppConstants.SK_EXCEL_TABLE);

Response.End();

Can anyone suggest me some thing to solve this issue.

Thank you
Ashwin

Pavlina

Admin

6187 posts

Posted 11 Aug 2009 Link to this post

Hi Ashwini,

Based on this information, it is hard to determine what is causing the problem you are facing.
If the issue persists, you can open a formal support ticket, and supply a small project, demonstrating your logic, for additional review.

Best wishes,
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.

sudheer

109 posts

Member since:
Dec 2008

Posted 11 Aug 2009 Link to this post

Hi Ashwin,

Have u checked Do not save encrypted pages to disk option in Tools-->Internet options -->Advanced-->security module
If checkbox is checked means uncheck and try might be help to get rid of it

Thanks & Regards
G.Sudheer kumar

Pavlina

Admin

6187 posts

Posted 12 Aug 2009 Link to this post

Hello Sudheer,

Thank you for sharing your approach with us. Your cooperation is highly appreciated and I believe that it should help in resolving this problem.
Please do not hesitate to contact us if any questions arise.

Greetings,
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.

sudheer

109 posts

Member since:
Dec 2008

Posted 12 Aug 2009 Link to this post

Hi Telerik team

While export grid which have more than 20000 records application gets system out of memory exception.
For your reference below image contains radgrid with around 40000 records
http://picasaweb.google.com/lh/photo/zxb2oz6yAVYr0hoEahtwYA?feat=directlink

while exporting i got error u can see in below URL
http://picasaweb.google.com/lh/photo/ykINe4NgeO3MAKVkpfpkkg?feat=directlink

Note :Radgrid upto 20000 records without any issues it's working fine, and cool without long span. I searchedin telerik forums and found excel 2003 can export 65000 records and 2007 supports morethan 1 lakh .so i tried in 2007 though no result .

Advanced thanks for any help.

Thanks & Regards
G.sudheer kumar

Pavlina

Admin

6187 posts

Posted 12 Aug 2009 Link to this post

Hello Sudheer,

Unfortunately there is little that can be done when trying to export large amounts of data. Exporting and storing such large amount of data in session variable will cause scalability problem. I can suggest you to consider decreasing the amount of data or export only the current page by setting the IgnorePaging option to 'false'.

Additionally, you can use the newer format using Microsoft Office Compatibility Pack. Otherwise you can split your data into different sheets.

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

sudheer

109 posts

Member since:
Dec 2008

Posted 28 Jan 2010 Link to this post

Hi Telerik team

I have implemented a new method for exporting grid into excel, even if the grid is having morethan 65000 records without
current page by setting IgnorePaging = 'false' it will work without any issues .I would like to share my idea with you how i implemented but i don't know how to attach and share the code (because i have created a class file, which creates a new worksheet in excel book and writes 10000 records of grid into it)

i tried with Support ticket through this URL http://www.telerik.com/account/support-tickets/new-support-ticket.aspx but no success.

For your quick reference If grid having 75000 records it will export into excel as 8 sheets( 7 pages 10000*7+5000*1) in the same workbook .

Thanks & Regards
G.Sudheer kumar

Pavlina

Admin

6187 posts

Posted 01 Feb 2010 Link to this post

Hi Sudheer,

To open support ticket you need to have an active subscription for the RadControls for ASP.NET. General information on Renewals and Upgrades you could review here:
http://www.telerik.com/purchase/upgrades.aspx

Regards,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

San

19 posts

Member since:
Nov 2012

Posted 24 Feb 2013 Link to this post

Hi
Openinnewwindows = 'false' functionality is not working in case of https website..

how do i rectify this problem..

Thanks
san

Pavlina

Admin

6187 posts

Posted 28 Feb 2013 Link to this post

Hi San,

Even if you set OpenInNewWindow="false", that doesn't guarantee that the file will be opened inside the browser window. The way the exported file will be displayed inline depends on the OS/browser settings. The end-user could manage the file extensions with programs like NirSoft's FileTypesMan. For browsers, other than Internet Explorer, you should use the built-in settings.

All the best,
Pavlina
the Telerik team

If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.