Export to excel problem in https site

[sudheer]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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

how do i rectify this problem..


Thanks
san

[Pavlina]

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