RadGrid Export to Excel - empty spreadsheet

7 posts, 0 answers
  1. Steven
    Steven avatar
    8 posts
    Member since:
    Jun 2008

    Posted 21 May 2009 Link to this post

    When I try to use the ExcelML format I always get an empty spreadsheet.  If I run the code with ExportToCSV instead of ExportToExcel, I get data, or if I just leave out the GridExcelExportFormat.ExcelML line (use the default format) with ExportToExcel I also get a spreadsheet.  Any ideas why I'm getting a blank spreadsheet when I use both the ExcelML format and ExportToExcel method?

     

    Me.RTLGrid1.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML

     

     

    Me.RTLGrid1.ExportSettings.ExportOnlyData = True

     

     

    Me.RTLGrid1.ExportSettings.OpenInNewWindow = True

     

     

    Me.RTLGrid1.MasterTableView.ExportToExcel()

     

     

    'Me.RTLGrid1.MasterTableView.ExportToCSV()

     

  2. Daniel
    Admin
    Daniel avatar
    4946 posts

    Posted 21 May 2009 Link to this post

    Hello Steven,

    Please try to enable UseAllDataFields property in MasterTableView:
    <MasterTableView UseAllDataFields="true" ... > 

    Best regards,
    Daniel
    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.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Steven
    Steven avatar
    8 posts
    Member since:
    Jun 2008

    Posted 21 May 2009 Link to this post

    Now I'm getting a message box "Problems During Load"  Problems came up in the following areas during load:  Table.  This file cannot be opened because of errors.

    The error log it says is created is on the client side but they are never created.  Excel does not load any spreadsheet after.

    Thanks,
  5. Steven
    Steven avatar
    8 posts
    Member since:
    Jun 2008

    Posted 21 May 2009 Link to this post

    I've somewhat solved it.  The problem with the Excel loading is that one of my fields has NULL for a datetime field and that causes Excel to choke when attempting to load.  If I put a date in the database column - it works with no issues.  Is there a way of telling the export to ignore that issue?

    Thanks,
  6. Daniel
    Admin
    Daniel avatar
    4946 posts

    Posted 26 May 2009 Link to this post

    Hello Steven,

    Sorry for the late answer. I tried to reproduce the problem but unfortunately without avail. Could you please provide a small runnable project which illustrates the problem? You can attach it to formal support ticket.

    Best regards,
    Daniel
    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.
  7. felipe
    felipe avatar
    5 posts
    Member since:
    May 2016

    Posted 13 Sep Link to this post

    Hi everyone,

     

    I have this same issue, when exporting to CSV it works fine but with export to excel it opens empty. this is happening to alla my applications and they used to work fine. Any help will be appreciated.

     

    thks in advanced!!!

  8. Konstantin Dikov
    Admin
    Konstantin Dikov avatar
    1803 posts

    Posted 16 Sep Link to this post

    Hello Felipe,

    Please refer to the following forum thread and see if the fix applies to your scenario:


    Regards,
    Konstantin Dikov
    Telerik by Progress
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017