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