Use UDF to use Sharepoint list data in Excel Service

When we use SharePoint for development, our data is stored in the Sharepoint list. Fortunately, Excel Service provides a UDF function, we can write a UDF function to use the data in the list.

Usage:

Select a range, type = getaskpointview (http://myserver.com, mysspsite, mylist, myview, true), and enter Ctrl + shft + enter.

If the last parameter is "no", it returns a data record. If the parameter is "true", the title is returned.

SourceProgramOut:

Http://blogs.msdn.com/luisbeonservices/archive/2006/09/28/consuming-sharepoint-lists-in-excel-services.aspx

Source program download:

/Files/dosboy/class1.zip