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

how to do GridViewSummaryItem of exceldispalyformatting

7 Answers 49 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Moe
Top achievements
Rank 1
Iron
Veteran
Iron
Moe asked on 26 Jul 2018, 08:56 AM

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.

7 Answers, 1 is accepted

Sort by
0
Moe
Top achievements
Rank 1
Iron
Veteran
Iron
answered on 26 Jul 2018, 08:57 AM
sry , first post miss out attach file
0
Moe
Top achievements
Rank 1
Iron
Veteran
Iron
answered on 26 Jul 2018, 08:59 AM
attach file
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 26 Jul 2018, 12:57 PM
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.
0
Moe
Top achievements
Rank 1
Iron
Veteran
Iron
answered on 27 Jul 2018, 02:17 AM

Dear Dess,

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

 

Thanks

Moe

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 30 Jul 2018, 12:39 PM
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.
0
Moe
Top achievements
Rank 1
Iron
Veteran
Iron
answered on 31 Jul 2018, 02:11 AM

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 . Now the column type is number but I can't find the thousand . May I know how to do it?

 

Thanks

Moe

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 31 Jul 2018, 11:45 AM
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.
Tags
GridView
Asked by
Moe
Top achievements
Rank 1
Iron
Veteran
Iron
Answers by
Moe
Top achievements
Rank 1
Iron
Veteran
Iron
Dess | Tech Support Engineer, Principal
Telerik team
Share this question
or