Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Anil
1590
Export to Predefined Excel with multiple headers
posted

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

Parents
No Data
Reply
  • 21382
    Suggested Answer
    posted

    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. 

Children