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

Export to excel problem in https site

14 Answers 282 Views
Grid
This is a migrated thread and some comments may be shown as answers.
sudheer
Top achievements
Rank 2
sudheer asked on 23 Apr 2009, 07:37 AM
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.

14 Answers, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 23 Apr 2009, 10:28 AM
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
0
sudheer
Top achievements
Rank 2
answered on 23 Apr 2009, 01:13 PM
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();
}

0
Pavlina
Telerik team
answered on 27 Apr 2009, 02:54 PM
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.
0
sudheer
Top achievements
Rank 2
answered on 27 Apr 2009, 03:10 PM
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);

0
Ashwini Kumar Varma Bhupathiraju
Top achievements
Rank 1
answered on 07 Aug 2009, 03:40 PM
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
0
Pavlina
Telerik team
answered on 11 Aug 2009, 03:25 PM
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.
0
sudheer
Top achievements
Rank 2
answered on 11 Aug 2009, 03:41 PM
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
0
Pavlina
Telerik team
answered on 12 Aug 2009, 09:43 AM
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.
0
sudheer
Top achievements
Rank 2
answered on 12 Aug 2009, 11:55 AM
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
0
Pavlina
Telerik team
answered on 12 Aug 2009, 02:34 PM
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.
0
sudheer
Top achievements
Rank 2
answered on 29 Jan 2010, 05:28 AM
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
0
Pavlina
Telerik team
answered on 01 Feb 2010, 03:20 PM
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.
0
San
Top achievements
Rank 1
answered on 24 Feb 2013, 12:43 PM
Hi
Openinnewwindows = 'false' functionality is not working in case of https website..

how do i rectify this problem..


Thanks
san
0
Pavlina
Telerik team
answered on 28 Feb 2013, 01:38 PM
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.
Tags
Grid
Asked by
sudheer
Top achievements
Rank 2
Answers by
Shinu
Top achievements
Rank 2
sudheer
Top achievements
Rank 2
Pavlina
Telerik team
Ashwini Kumar Varma Bhupathiraju
Top achievements
Rank 1
San
Top achievements
Rank 1
Share this question
or