Export


To get an idea on this component, read about it from SharePoint 2010 - Export selected items to excel. Its time to provide some updates on  the SharePoint export selected items to excel for some fixes.

The look-up columns shows with the special characters 
When the custom list has some look-up columns associates with it, after exporting the selected items to excel it shows the columns values in the format "ID#;Value". Now this has been fixed to show only the values. If multiple values are associated to the list then it will be comma separated value.i.e. "ID#;Value1;ID#;Value2" will be exported as "Value1;Value2".

The export to excel option shows in the New group in the ribbon 
The export to excel button control was displayed in the New group, and its changed to the Share & Track group which makes more sense now.


UTF8 characters not showing properly in excel
I received mail about this issue that the UTF8 character are not showing properly in excel, so added the fix for the same. I don't have language pack installed for other languages, but I tried to test  most of the scenarios. Need to test more on the other languages as well.

Where is the wsp?
 You can download the solution/wsp from the codeproject site, which is labeled as Release 1.1.0.

Note

The deployment steps remains the same, even after the code level changes involved in the above fixes. If you have already deployed the solution, I would suggest to follow the upgradesolution sequence.

Comments

Post a Comment