Skip to main content

"Export to Spreadsheet" option in SharePoint list web part does not export all the columns

We all knew that the SharePoint list can be embedded in a web part page using the list web part. The list web part provides us with various properties which can be customized as per the requirement. One such property is the "Toolbar" . If "Show Toolbar" option is set, we would be provided with 3 tabs namely "New", "Actions" and "Settings". 

The list data can be exported to an excel using the "Export to Spreadsheet"  option found under the "Actions" tabs. 

Now here is the issue, suppose we have 10 columns in the list and we would like to show only 5 columns in the page, we would create a view in such a way that the page shows only the 5 columns.  If the data is exported from this page using the "Export to Spreadsheet" option, all the columns would definitely get exported, but the values would be exported only for those 5 columns which are shown on the page. This is because, the "Export to Spreadsheet" is taking only the display fields in the view instead of taking all the columns in the list.

User does not want to use the default list page where we have the "Export to Excel" option in the SharePoint Ribbon section. 

So what do we do? 

It's simple :) Place a custom "Export to excel" button on the page where the list view web part has been added. This would export all the data irrespective of the fields displayed in the view.

Please add the below html snippet to a content editor web part to create the "Export to excel" button on the page.

<button type="button" <a href"#" onclick="javascript:window.location='SITEURL/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={YOUR LIST ID}&View={YOUR VIEW ID}&CacheControl=1'">Export to Excel</a></button>

Please note that the LIST ID and VIEW ID are decoded ids. You may decode the IDs from here : https://meyerweb.com/eric/tools/dencoder/


How to get the LIST and VIEW ID?? 

Please go to the list settings page and copy the URL,  you would get the LIST ID where the url would be like http://sharepoint.com/_layouts/15/listedit.aspx?List=LISTID.
Similarly, please click on the Views to get the VIEW ID.

Now the "Export to Excel" would work like a charm! 

Happy SharePointing!!! 





Comments

Post a Comment

Popular posts from this blog

This site has exceeded its maximum storage limit.Error while uploading file to document library - SharePoint

Issue:  Unable to upload files to SharePoint document library irrespective of the document size. Solution: When you delete items from a SharePoint site, they're sent to the site Recycle Bin. When you delete items from a site Recycle Bin, they're sent to the site collection Recycle Bin.  A SharePoint site collection administrator can view and restore deleted items from the site collection Recycle Bin to their original locations. If an item is deleted from the site collection Recycle Bin, or it exceeds the retention time, it is permanently deleted. 1. Click the gear icon and go to the "Site Settings" page. 2. Under the Site Collection Administration, click on "Recycle bin". 3. Delete the unwanted files.
Post a Comment
Read more

How to Migrate a InfoPath List Form to another List Form in SharePoint 2013

I encountered an issue recently where the Info Path form got published accidentally with improper layout. As we all know that Info Path does not maintain versions and it is impossible to revert to the previous versions.  Luckily I had the back up of the SharePoint list template from where I could open the previous version of the Info path form. Following are the steps I tried to migrate the Info Path form from the back up to the new SharePoint list. 1. Create a new SharePoint list from the list template. 2. Open the newly created list and click on "Customize form" to open the form in Info path designer. 3. Extract the source files by clicking on File->Publish-> Export Source Files. 4. Update the manifest file with the URL, List ID, Content Type ID of the list to which the Info path form has to be published. Steps to update the manifest file: 1. Get the List ID from the URL by clicking on List settings. The List Id would be something like  List=%7B691FF1A0%2...
Post a Comment
Read more

Service Unavailable Error while accessing SharePoint Central Admin

Central Administration in SharePoint Server is where you go to perform administration tasks from a central location.  Sometime we encounter the "Service Unavailable" error message while trying to access the central admin.  Please follow the steps below to resolve the issue. 1. Open the IIS.  2. Expand the server name. 3. Click on Application Pools. 4. Please check whether the Central Admin application pool is started. If not, please start. 5. Also check whether the Central Admin site is started by expanding the "Sites". Sometimes the issue persists even after starting the application pool and the site. In that case, please go to the application pool. Click on advanced settings-> Identity->Please enter the credentials in the App Pool Identity and save.
Post a Comment
Read more