Click or drag to resize

SheetResources Methods

The SheetResources type exposes the following members.

Methods
  NameDescription
Public methodCopySheet(Int64, ContainerDestination, IEnumerableSheetCopyInclusion)

Creates a copy of the specified sheet.

Mirrors to the following Smartsheet REST API method:
POST /sheets/{sheetId}/copy

Public methodCopySheet(Int64, ContainerDestination, IEnumerableSheetCopyInclusion, IEnumerableSheetCopyExclusion)

Creates a copy of the specified sheet.

Mirrors to the following Smartsheet REST API method:
POST /sheets/{sheetId}/copy

Public methodCreateSheet

Creates a sheet in default "Sheets" collection.

Mirrors to the following Smartsheet REST API method:
POST /Sheets

Public methodCreateSheetFromTemplate

Creates a sheet (from existing sheet or template) in default "Sheets" collection.

Mirrors to the following Smartsheet REST API method: POST /Sheets

Public methodDeleteSheet

Deletes a sheet.

Mirrors to the following Smartsheet REST API method: DELETE /sheets/{sheetId}

Public methodGetPublishStatus

Gets the status of the publish settings of the sheet, including the URLs of any enabled publishings.

Mirrors to the following Smartsheet REST API method: GET /sheets/{sheetId}/publish

Public methodGetSheet(Int64, IEnumerableSheetLevelInclusion, IEnumerableSheetLevelExclusion, IEnumerableInt64, IEnumerableInt32, IEnumerableInt64, NullableInt64, NullableInt64)

Gets a sheet.

Mirrors to the following Smartsheet REST API method: GET /sheets/{sheetId}

Public methodGetSheet(Int64, IEnumerableSheetLevelInclusion, IEnumerableSheetLevelExclusion, IEnumerableInt64, IEnumerableInt32, IEnumerableInt64, NullableInt64, NullableInt64, NullableInt64)

Gets a sheet.

Mirrors to the following Smartsheet REST API method: GET /sheets/{sheetId}

Public methodGetSheet(Int64, IEnumerableSheetLevelInclusion, IEnumerableSheetLevelExclusion, IEnumerableInt64, IEnumerableInt32, IEnumerableInt64, NullableInt64, NullableInt64, NullableInt64, NullableInt32)

Gets a sheet.

Mirrors to the following Smartsheet REST API method: GET /sheets/{sheetId}

Public methodGetSheetAsCSV

Gets a sheet as a CSV file.

Mirrors to the following Smartsheet REST API method:
GET /sheets/{sheetId} with "text/csv" Accept HTTP header

Public methodGetSheetAsExcel

Gets a sheet as an Excel file.

Mirrors to the following Smartsheet REST API method:
GET /sheets/{sheetId} with "application/vnd.ms-excel" Accept HTTP header

Public methodGetSheetAsPDF

Gets a sheet as a PDF file.

Mirrors to the following Smartsheet REST API method:
GET /sheets/{sheetId} with "application/pdf" Accept HTTP header

Public methodGetSheetVersion

Gets the sheet version without loading the entire sheet.

Mirrors to the following Smartsheet REST API method: GET /sheets/{sheetId}/version

Public methodImportCsvSheet

Imports a sheet (from CSV).

Mirrors to the following Smartsheet REST API method: POST /sheets/import

Public methodImportXlsSheet

Imports a sheet (from XLSX).

Mirrors to the following Smartsheet REST API method: POST /sheets/import

Public methodListOrganizationSheets Obsolete.

Lists all sheets in the organization.

Mirrors to the following Smartsheet REST API method: GET /users/sheets

Public methodListSheets

Gets the list of all sheets that the user has access to, in alphabetical order, by name.

Mirrors to the following Smartsheet REST API method: GET /Sheets

Public methodMoveSheet

Moves the specified sheet to a new location.

Mirrors to the following Smartsheet REST API method:
POST /sheets/{sheetId}/move

Public methodSendSheet

Sends a sheet as a PDF attachment via email to the designated recipients.

Mirrors to the following Smartsheet REST API method: POST /sheets/{sheetId}/emails

Public methodSendUpdateRequest Obsolete.

Creates an update request for the specified rows within the sheet. An email notification (containing a link to the update request) will be asynchronously sent to the specified recipients.

Mirrors to the following Smartsheet REST API method: POST /sheets/{sheetId}/updaterequests

Public methodSortSheet(Int64, SortSpecifier)

Sorts a sheet according to the sort criteria.

Mirrors to the following Smartsheet REST API method: POST /sheets/{sheetId}/sort

Public methodSortSheet(Int64, SortSpecifier, NullableInt32)

Sorts a sheet according to the sort criteria.

Mirrors to the following Smartsheet REST API method: POST /sheets/{sheetId}/sort

Public methodUpdatePublishStatus

Sets the publish status of a sheet and returns the new status, including the URLs of any enabled publishings.

Mirrors to the following Smartsheet REST API method: PUT /sheets/{sheetId}/publish

Public methodUpdateSheet

Updates a sheet.

To modify sheet contents, see Add Rows, Update Rows, and Update Column.

This operation can be used to update an individual user’s sheet settings. If the request body contains only the userSettings attribute, this operation may be performed even if the user only has read-only access to the sheet (i.e., the user has viewer permissions, or the sheet is read-only).

Mirrors to the following Smartsheet REST API method: PUT /sheets/{sheetId}

Top
See Also