Export to Excel a XamDataGrid apply the proper style

215

Kos Pat posted over 8 years ago

Hello,

I am currently having a XamDataGrid and I want to export it into an Excel spreadsheet. Can you help me with the following 2 questions:

How can I apply row background color and alternative row background color
How can I adjust the foreground color of a cell based on the color of the cell in the grid (I am using a styleselector to choose the foreground color)

Thank you

Parents

35319

[Infragistics] Yanko posted over 8 years ago

Hi Kos,

Thank you for your post. I have been looking into your question and you could look into the Custom Export Cell Styling sample in our Samples Browser(xamDataGrid -> Styles) in order to see how to apply style settings when exporting the XamDataGrid to Excel.

Let me know, if you need any further assistance on this matter.
Cancel
Reply

Cancel
215

Kos Pat posted over 8 years ago in reply to [Infragistics] Yanko

Hi Yanko,

I revised all the sample code that you suggested but I couldn't find solutions to my problems. All the sample code applies the style to all the rows of a column. The style selector gives you the freedom to apply different style to each row of a column based on the cell content.

Also I couldn't find a sample that applies row background and alternative row background at the excel exported spreadsheet.

Is there a way to add this styles?

Thank you
Cancel
Reply

Cancel
35319

[Infragistics] Yanko posted over 8 years ago in reply to Kos Pat

Hi Kos,

I am attaching a sample application(DataGridExportToExcelStylesColumns.zip) that shows how to export the XamDataGrid with the background of the records. You can see all the properties that you can see all the properties related to the formatting in e.FormatSetting in the RecordExporting event.

Let me know, if you need any further assistance on this matter.

DataGridExportToExcelStylesColumns.zip
Cancel
Reply

Cancel
215

Kos Pat posted over 8 years ago in reply to [Infragistics] Yanko
Hi Yanko,

Thanks a lot. The sample work perfect. But I have two other questions regarding Excel export.

As you can see in the attached sample project, I have a XamDataGrid with UnboundFields fields. The column span of the UnboundFields is greater than 1. As you can see when you export the grid only the first cell of the two merged cells have border.

My question are the following:

Is there a way to fix the border problem and apply it in the whole merged cell

Is there a way to insert some extra rows above the grid after the grid has been exported (e.g. to add a header above the grid)

Thank you again
XamDataGridExcelExport.zip
Cancel
Reply

Cancel
35319

[Infragistics] Yanko posted over 8 years ago in reply to Kos Pat

Hi,

Thank you for your reply. I have been looking into your questions and I can suggest you look into the following forum thread in order to understand how to add an additional row in the Excel file:

http://www.infragistics.com/community/forums/t/72256.aspx

Regarding the issue with the border style I have submitted this behavior in our tracking system, with an issue ID of 194203. I have also created a support ticket on your behalf with number CAS-155574-R0K5M6 in order to link the development issue to it so that you are automatically updated when a Service Release containing your fix is available for download.

Please in future create a new thread for each of your new questions.
Cancel
Reply

Cancel

Reply

22015

[Infragistics]Gergana Dimitrova posted over 8 years ago in reply to [Infragistics] Yanko

Hello,

We have shipped out a new service release where your issue is resolved. I'd be glad to find out if you had tested it out and if it had met your requirements.

You can download the Service Releases by logging to our web site and going to Account\My Keys and Downloads.
Cancel
Reply

Cancel

Children

No Data