Thursday, January 5, 2017

How to Create an Export to Excel Link on Any List or Library for 2010 and 2013

Generate the below URL for any list / library

SiteURL/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={List ID}&View={View ID}&CacheControl=1


Ex:

http://SharepointSiteCollection:80/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={XXXXXXXX-XXXX-XXXX-XXXXXXXXX&View={XXXXXXXX-XXXX-XXXX-XXXXXXXXX}&CacheControl=1


Note : For List ID and View ID, you could get it from List Setting page and View page respectively

No comments:

Post a Comment