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,
I am just checking your progress on the issue. If you require any further assistance please do not hesitate to ask.
Hello Ben,
I have been investigating your issue. After the investigation I have modified the previous sample with the functionality you have mentioned and I could not managed to reproduce your issue. Would you please modify the sample with your functionality in order to be able to provide you with better support.
I am looking forward to hearing from you.
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.
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.