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.
foreach (var item in xamDataGrid.DataSource)
{
var dataRecord = xamDataGrid.GetRecordFromDataItem(item, false);
var color = dataRecord.Cells[1].DataPresenter.Background;
}
HI,
I am just following up on this forum thread.
Please let me know if you require further assistance.
Sincerely, Matt Developer Support Engineer
Thanks, but it does not work - always getting #FFFFFFFF value.
Background is set with DataTriggers for
FieldLayoutSettings.DataRecordCellAreaStyle
Any other ideas?