Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Excel Add-In for Microsoft SharePoint Views
| Name | Description |
| Attachments | Reads attachments to the specified item to the specified list. |
| Comments | This view represents comments within SharePoint, detailing their authors, content, replies, and associated metadata. |
| Files | Reads attachments to the specified item to the specified list. |
| Groups | Retrieve group information from the specified SharePoint Site, including membership settings, permissions, and ownership details. |
| Lists | Query the available lists on your sharepoint site. |
| ListItems | This view represents general SharePoint items containing standard columns across various SharePoint lists. |
| RoleAssignmentMember | Get Web RoleAssignments member. |
| RoleAssignments | Acquires Web RoleAssignments. |
| RoleDefinitionBindings | Get Web Role definition binding. |
| Roles | Contains details about role definitions available in the SharePoint site collection. |
| Subsites | This lists the available subsites. |
| Users | Represents users and their roles in the SharePoint site or group. |