Today I ran into a scenario where requirement was to NOT use the ribbon to export the list to excel but access it via the left navigation.
After some research I could find a way to do this:
http://[Server]/[Site]/([Subsite]/)_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[ListGUID]&View=[ViewGUID]&CacheControl=1
Replace the [Placeholders] with your specific values.
One way to get the list and view GUIDs is to go into "List settings" then scroll down to the views section and click on the view that you want to use.
Here is an example:
http://development004:100/_layouts/ViewEdit.aspx?List=%7B9B8241B3%2D7F09%2D4F45%2DBEE3%2D755E3F7C3FE4%7D&View=%7B70A055C3%2DAEAD%2D4006%2DAB79%2D93D3E700EEC4%7D
Breaking the above :
List=%7B9B8241B3%2D7F09%2D4F45%2DBEE3%2D755E3F7C3FE4%7D
View=%7B70A055C3%2DAEAD%2D4006%2DAB79%2D93D3E700EEC4%7D
Another Tip :
If you are getting the error displaying the list in Data sheet view download and install
http://www.microsoft.com/en-us/download/details.aspx?id=23734
No comments:
Post a Comment