Hi,
I Have a very complex predefined Excel template. It is having multiple column headers like main headers and sub headers. But I need to do is export the data from xamgrid to the predefined excel template. The problem is some columns are hidden and merged so I need to Export the data to only specific columns of the each excel row. Even I want to export the exact data in the xamGrid to excel with the format.
Please let me know how can I achieve this using Infragistics Excel.
Thanks in Advance
Hi Crisil,
See this post where similar question was discussed. I hope it helps: watermark in Excel
Hi ,i want export xamgrid to excel .i have got this. but i need export xamgrid data to excel with water mark background.
Currently for our Silverlight grid we do not have an independent exporter. It is a feature for our 11.2 release. However if your template is that complex you would be best off crafting your own solution using the Excel API.
With that being said, with the Excel API you can open up and layout your document layout and place values in any cell that is available. So you would be able to iterate through the Rows collection of the XamGrid, grabbing out the values of the cells you are interested in and then writing them to spreadsheet.