Visit also my other projects on CodePlex:
http://sharepointsmfu.codeplex.com - SharePoint 2010 SilverLight Multiple File Uploader
http://spcolumnpermission.codeplex.com - SharePoint Column & View Permission
Visit also my other projects:
Version 1.2 Now Available:
Fixed issues with Page Not Found
External dll files included in WSP directly
As you already know, there is no possibility in SharePoint 2010 to export any external lists to excel file like with other lists or document libraries. Therefore I have created simple plugin, which will install new ribbon button to any external list on SharePoint
site collection. After you click on this button the modal dialog window will pop up and you can choose to which excel file type (office 97 - 2003 or to office 2007 - 2010) you want to export current external list.
Your export will export not only current external list but also current selected view.
1. Download ExportToExcel.zip file and unzip it
2. You will see three folders.
3. (If you are installing version 1.2 of this feature you can skip this first step) First go to folder
1. Install dll and run setup.bat - this will install needed dll files to GAC. If you have some problem to install it from setup.bat please install it manually to GAC. Or if you have some of these dll’s already install only those
4. Now go to folder 2. Install Jquery and run setup.exe. This will install Jquery to your site collection headers.
If you already use jquery on your site collection you don't need this custom header.
5. Finally go to folder 3. Install ExportExternalList and run setup.exe. This will install Export To Excel button to any external list.
If you don't like included setup files you can simply install everything manually from PowerShell.
You don't need MS Office installed on SERVER!
If you will find any bugs please let me know at
email@example.com or post your findings in Issue Tracker.
If you don't need the office 97 - 2003 version of export please use office 2007 - 2010 export. This export is much more professional.
Thanks goes to:
Carlos Aguilar Mares - http://www.carlosag.net/tools/excelxmlwriter/
MDeLeon - http://closedxml.codeplex.com/