Export to excel problem in https site

15 posts, 0 answers
  1. sudheer
    sudheer avatar
    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.
  2. Shinu
    Shinu avatar
    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
  3. sudheer
    sudheer avatar
    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();
    }

  4. Pavlina
    Admin
    Pavlina avatar
    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.
  5. sudheer
    sudheer avatar
    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);

  6. Ashwini Kumar Varma Bhupathiraju
    Ashwini Kumar Varma Bhupathiraju avatar
    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
  7. Pavlina
    Admin
    Pavlina avatar
    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.
  8. sudheer
    sudheer avatar
    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
  9. Pavlina
    Admin
    Pavlina avatar
    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.
  10. sudheer
    sudheer avatar
    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
  11. Pavlina
    Admin
    Pavlina avatar
    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.
  12. sudheer
    sudheer avatar
    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
  13. Pavlina
    Admin
    Pavlina avatar
    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.
  14. San
    San avatar
    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
  15. Pavlina
    Admin
    Pavlina avatar
    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.
Back to Top