I have formatted couple of Columns within the XAMDataGrid using the following Feature
<Style TargetType="{x:Type igEditors:XamNumericEditor}"> <Setter Property="Mask" Value="nnn,nnn,nnn,nnn.nn"/> <Setter Property="NullText" Value="-" /> </Style>
However when I export the Grid to Excel, the formatting of number is lost for e.g. the comma's go missing. Also huge numbers like 150000000000 are displayed as 1.5E+11. Numbers with decimal places as XXX.00 are displayed as XXX. When we manually change the format on the excelsheet to number, the value displayed is as desired.
I am not able to manually export each row and each column as the Grid might have grouping which we wish to have in the same format while export to excel.
Can you please help me with this?
Hello Aniket,
When exporting a formatted field the formatting are not exported in to excel, sice the format strings are different form the one you set in xamDataGrid. You can set the formatting during the exporting of the data by handling the CellExported event and set the corresponding formatting. You can set the same formatting that are valid for excel double numbers. See attached sample for your reference.
You can see more details in to the example “Workbook Object Model” under Excel engine in to Sample Browser. If you need to export the style of the fields you can look at the sample Custom Excel Export Cell Style under the XamDataGrid-> styles in to sample browser.
Hope this helps you.
One further question to your response for Custom Excel Export Cell Style example.
I have a XamDataGrid shown on screen and based on various data triggers it has specific look and feel. Is it possible to export that situation (specific styled) in Excel?