Excel Add-In for Microsoft SharePoint

Build 24.0.8963

Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Microsoft SharePoint.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft SharePoint, along with an indication of whether the procedure succeeded or failed.

CData Excel Add-In for Microsoft SharePoint Stored Procedures

Name Description
AddAttachment Add an Attachment to a SharePoint List item.
AddList Creates a list on a SharePoint site.
AddListColumn Adds a new column to the specified list.
AddUserToGroup Add the user to specified group.
AddUserToRole Add the user to specified role.
CheckInDocument Checks in a document to SharePoint and releases the lock on the document.
CheckOutDocument Checks out a document from SharePoint.
CopyDocument Copies a document from the SharePoint library.
CreateFolder Adds a folder to a document library on a SharePoint site.
CreateSchema Creates the schema file for the specified SharePoint list. The schema file may be customized manually to exclude unwanted columns or include additional information about columns.
DeleteAttachment Deletes an attachment from a SharePoint list item.
DeleteDocument Deletes a document on the SharePoint library.
DeleteList Permanently deletes a list from a SharePoint site.
DeleteListColumn Deletes a column from the specified list.
DeleteUserFromGroup Deletes the user from the specified group.
DeleteUserFromRole Deletes the user from specified role.
DiscardCheckOutDocument Discards a check out on a document in SharePoint. This does not check a new file into SharePoint. It only releases the lock on the document.
DownloadAttachment Downloads a document from the SharePoint list.
DownloadDocument Downloads a document from the SharePoint library.
MoveAttachmentOrDocument Moves a document or attachment from a source folder to a destination folder.
RenameAttachmentOrDocument Renames a document or attachment.
UpdateList Updates a list on a SharePoint site.
UpdateListColumn Updates a column to the specified list.
UploadDocument Uploads a document to the SharePoint library.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963