I am trying to export XamDataGrid to excel.
Question: how do I export format settings?
Let's say I have one column showing currency and another showing percentage.
Both are double values. I need it exported to excel with number formatting.
Is it possible to do?
Is it possible to access somehow cell's ValueEditor.Format property from the code?
Another problem:
I am setting bacground property of DataRecordCellAreaStyle at runtime.
The style has datatriggers and depending on particular field value it sets row background color.
Now I want to export that color to excel as well. I can't find the way to read that color from the cell or row...
Thanks
Hi Dierk,
did you downloaded XAM Feature Browser? There is a sample in xamDataGrid->Excel Exporter called Custom Cell Styling. I think this sample will answer most of your questions.
You can apply any formatting using the "FormatString" property of the igExcelExporter:FormatSettings
Thanks, but this is not what my question was about.
My question was how to read the cells/rows background brush from the grid?
Once I know the color, then I can use FormatString to pass that color. But I need to know that color first.