For example, if XamGird is set Column as movable, sortable, can be hided. After data loaded, the change order of column, hide some column, then export to excel.
Want data in Excel has same column order, also hide the column as Xamgrid.
Is it possible do it with Export to Excel? How to do it? sample code please. Thanks.
Hello Ben,
I have been investigating your issue. After the investigation I have created a small sample for you, named ExportXamGridtoExcel. In it is shown the functionality you have mentioned. Here is a link where you can find more information about exporting the XamGrid to Excel: http://help.infragistics.com/Help/NetAdvantage/Silverlight/2012.2/CLR4.0/html/xamGrid_Exporting_to_Excel%20.html. Please refer to the attached sample and feel free to let me know if you need any further assistance.
Thank you. Have try it. My Xamgrid has following setting:
<ig:PersistenceManager.Settings> <ig:PersistenceSettings SavePersistenceOptions="AllButIgnored" LoadPersistenceOptions="AllButIgnored"> <ig:PersistenceSettings.PropertySettings> <ig:PropertyNamePersistenceInfo PropertyName="Columns[].FilterColumnSettings" Options="Contains"/> </ig:PersistenceSettings.PropertySettings> </ig:PersistenceSettings> </ig:PersistenceManager.Settings>
When I try your code to export, I got error:
PersistenceGroup elements don't match elements in stream.