how to do GridViewSummaryItem of exceldispalyformatting

8 posts, 0 answers
  1. Moe
    Moe avatar
    21 posts
    Member since:
    Jan 2018

    Posted 26 Jul 2018 Link to this post

    Hi admin,

     

    I would like to know GridViewSummaryItem with excel cell format of the number when export to excel (using ExportToExcelML). I can do each column of formatting but summary column not showing 'Number' in excel, just show 'General' format. Please, my attached file.

  2. Moe
    Moe avatar
    21 posts
    Member since:
    Jan 2018

    Posted 26 Jul 2018 Link to this post

    sry , first post miss out attach file
  3. Moe
    Moe avatar
    21 posts
    Member since:
    Jan 2018

    Posted 26 Jul 2018 in reply to Moe Link to this post

    attach file
  4. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3575 posts

    Posted 26 Jul 2018 Link to this post

    Hello, Moe,    

    It seems that you missed to provide the attachment. According to the brief description I suppose that you need to export the summary cell's values as numbers. However, the default format that is used is Generel when exporting either with the ExportToExcelML, or with the GridViewSpreadExport. We already have a similar issue logged for RadGridView. You can track its progress, subscribe for status changes and add your comments on the following link: https://feedback.telerik.com/Project/154/Feedback/Details/243818-fix-radgridview-exported-summary-items-value-is-not-considered-as-a-number-in 

    Feel free to use the GridViewSpreadExport and its CellFormatting event as it is demonstrated in the referred feedback item in order to modify the format of the exported summary value.

    I hope this information helps. If you have any additional questions, please let me know.  
     
    Regards,
    Dess
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  5. Moe
    Moe avatar
    21 posts
    Member since:
    Jan 2018

    Posted 26 Jul 2018 Link to this post

    Dear Dess,

    In ExportToExcelMLdon't have CellFormatting event. So may I know how to do in ExportToExcelML? I don't GridViewSpreadExport because I want to export exactly like the radgridview what have group data. How to change radgridview of summaryitem formatting in excel?

     

    Thanks

    Moe

  6. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3575 posts

    Posted 30 Jul 2018 Link to this post

    Hello, Moe,    

    Note that the GridViewSpreadExport is a more flexible and easy to use and customize exporter compared to the old ExportToExcelML. The GridViewSpreadExport exposes API which allows you to specify the data format of the cells as it is demonstrated in the previously referred feedback item. The ExportToExcelML doesn't expose such API and it is not possible to customize the exported document is such a way. The issue is logged and it will be addressed for the new GridViewSpreadExport which is implemented by using the Document processing libraries. There is no identical solution for the ExportToExcelML due to the specificity of the export's implementation.

    I would highly recommend you using the GridViewSpreadExport as it is a more easy tuning exporter which allows exporting to xlsx, csv, pdf and txt formats. 

    I hope this information helps. If you have any additional questions, please let me know.  
     
    Regards,
    Dess
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  7. Moe
    Moe avatar
    21 posts
    Member since:
    Jan 2018

    Posted 30 Jul 2018 in reply to Dess | Tech Support Engineer, Sr. Link to this post

    HI Dess,

    Thank you for replying. Now I am using GridViewSpredExport. When I export to excel I want the column type is the number with thousand separator. Now the column type is number but I can't find the thousand separator. May I know how to do it?

     

    Thanks

    Moe

  8. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3575 posts

    Posted 31 Jul 2018 Link to this post

    Hello, Moe,    

    Each column in RadGridView has ExcelExportType property which can be used for explicitly setting the data type of the cells in the exported document. In order to change the format of the exported data, you can set the ExcelExportType property of the specific column to Custom and specify the ExcelExportFormatString property with the desired format. The following help article is quite useful for specifying the desired format: Format Codes

    I hope this information helps. If you have any additional questions, please let me know.  
     
    Regards,
    Dess
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top