Thursday, March 24, 2016

SharePoint -Export List to Excel from Custom Link

 Steps to export ( excel ) list view from custom hyper link or button or JavaScript.

 1.  Add regular hyperlink href or button or java script function and look for the onclick event

2.  Update the  href/url part to the below given pattern
<server URL>/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=<List ID>&View=<View ID>
You can get the List ID or View ID  when you modify a view or from list setting page

3. Save and start exporting a view directly instead of ribbon command!


Happy Browsing!
Relax..