Skip to main content

Create Export to Excel option for list as button control in page

In Sharepoint 2010, in the list ribbon there is an option Export to Excel, to get the list data in excel format.

The same option can be given to the end user on click of a button in the page

Create a content editor webpart. In the html source enter the following code

<button type="button"  <a href="#" onclick="javascript:window.location='../_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=ListGuid&View=ViewGuid&CacheControl=1'"><img src="/_layouts/images/icxlsx.gif" border="0"/>&nbsp;&nbsp; Export to Excel</a> </button>
Labels:

Comments

  1. Unknown30 November 2016 at 17:42

    Great. But what if i want to get only the filtered items exportet to excel. for example i filter the list on Created by. It still downloads the complete list

    ReplyDelete
  2. laelefacteau25 February 2022 at 18:04

    CASINO 100% NEWEST CASINO - CBS News
    The casino 파라오슬롯 was 토토 배당률 built in 1996. The 바카라배팅법 company is now a joint venture 일반인 후방 between 188벳 Caesars Entertainment and Bally Interactive. The brand features a new,

    ReplyDelete

Post a Comment

Popular posts from this blog

Cannot open SharePoint 2010 Approval task form from Outlook

When trying to click on Open this task from Outlook 2010, it brings an error - " Outlook cannot open a new form. The form contains schema validation errors" Element '{ http://www.w3.org/1999/xhtml}div ' is unexpected according to the content model of parent element '{ http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields}Body '. As given in the error message, the issue is with the Body column of the workflow tasks list. For the approval workflow, there would be a tasks list. In the workflow task list, the Body column is Enhance Rich multi-line column. Change the setting to Plain text, instead of enhanced rich text. After that do an iisreset.
7 comments
Read more

How to link to Download a copy option in Office 365/SharePoint 2013

At times it is required to have the option to save a copy of a document uploaded in SharePoint document library, in a page or a webpart. The url to get the save option for a doc is - http:// site /_layouts/download.aspx?SourceUrl= url-of-document-in-library Change the bold text with the actual url, i.e., with the site url and the url to the doc in the doc library. For example, if the site is www.contso.com and the doc "Test" is uploaded in SiteAssets library, the url to save a copy would be - http://contso.com/_layouts/download.aspx?SourceUrl=http://contso.com/SiteAssets/Test.docx
1 comment
Read more

Examples of utility function in SPD 2010 workflows

In SPD workflows, under Actions, there is a set of Utility functions. Using the substring function, a string can be trimmed from the beginning/end/or from a position, with or without specifying the length. An example, to remove the domain part from the user name, e.g. abcdomain/username, follow the below steps 1.        Use “Extract substring from the index of string” 2.        It would insert a step in WF as “Copy from string , starting at 0 (Output to Variable: substring ) 3.        Click on ‘string’ and click fx to get the field to be trimmed. 4.        It would bring the look-up window. 5.        Select the field and click OK. In this e.g., Data Source: Current Item and Field from Source: Created By 6.        To set the index, click on 0 and enter the required number, here it would be 1...
1 comment
Read more