Excel Add-In for Smartsheet

Build 24.0.9060

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 Smartsheet Views

Name Description
Info_CellHistory Query the available CellHistory of a Cell in Smartsheet.
Info_Cells Query Smartsheet Cells. A collection of Cells comprises each Row in a Sheet.
Info_Contacts Query Smartsheet Contacts. A Contact is the personal contact of a User in Smartsheet.
Info_Favorites Query Smartsheet Favorites.
Info_Folders Query Smartsheet Folders in the Sheets Folder for the User, in another Folder, or in a Workspace.
Info_Groups Query Smartsheet Groups.
Info_Home Query objects on the Home tab in Smartsheet. The Home tab shows all objects a User has access to.
Info_Reports Query Smartsheet Reports.
Info_Rows Query Rows in a Sheet or Report. Each Row is composed of a collection of Cells, and may optionally contain Discussions and Attachments.
Info_ServerInformation Query Smartsheet Server Information including application constants.
Info_Shares Query the Sharing operations of Reports, Sheets, and Workspaces.
Info_Sheets Query Smartsheets Sheets. A Sheet can exist in the Sheets folder for the user (Home), in a Folder, or in a Workspace. It is comprised of Columns, Rows, and Cells, and may optionally contain Attachments and Discussions.
Info_Templates Query Smartsheet Templates.
Info_Users Query the Users in the organization.
Info_Workspaces Query Smartsheet Workspaces.

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