how to do GridViewSummaryItem of exceldispalyformatting

[Moe]

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.

[Moe]

sry , first post miss out attach file

[Moe]

attach file

[Dess | Tech Support Engineer, Principal]

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

[Moe]

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

[Dess | Tech Support Engineer, Principal]

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

[Moe]

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

[Dess | Tech Support Engineer, Principal]

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