SheetResourcesImportXlsSheet Method

Imports a sheet (from XLSX).

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

Namespace: Smartsheet.Api
Assemblies: smartsheet-csharp-sdk (in smartsheet-csharp-sdk.dll) Version: 2.126.0
smartsheet-csharp-sdk (in smartsheet-csharp-sdk.dll) Version: 2.126.0

Syntax

C++

Copy

Sheet ImportXlsSheet(
	string file,
	string sheetName,
	Nullable<int> headerRowIndex,
	Nullable<int> primaryColumnIndex
)

Function ImportXlsSheet ( 
	file As String,
	sheetName As String,
	headerRowIndex As Nullable(Of Integer),
	primaryColumnIndex As Nullable(Of Integer)
) As Sheet

Sheet^ ImportXlsSheet(
	String^ file, 
	String^ sheetName, 
	Nullable<int> headerRowIndex, 
	Nullable<int> primaryColumnIndex
)

abstract ImportXlsSheet : 
        file : string * 
        sheetName : string * 
        headerRowIndex : Nullable<int> * 
        primaryColumnIndex : Nullable<int> -> Sheet

Parameters

file: Type: SystemString
path to the XLSX file
sheetName: Type: SystemString
destination sheet name
headerRowIndex: Type: SystemNullableInt32
index (0 based) of row to be used for column names
primaryColumnIndex: Type: SystemNullableInt32
index (0 based) of primary column

Return Value

Type: Sheet
the created sheet

Exceptions

Exception	Condition
InvalidOperationException	if any argument is null or an empty string
InvalidRequestException	if there is any problem with the REST API request
AuthorizationException	if there is any problem with the REST API authorization (access token)
ResourceNotFoundException	if the resource cannot be found
ServiceUnavailableException	if the REST API service is not available (possibly due to rate limiting)
SmartsheetException	if there is any other error during the operation

Reference

SheetResources Interface

Smartsheet.Api Namespace

SheetResourcesAddLanguageSpecificTextSet("LST6BAC6B8B_0?cpp=::|nu=.");ImportXlsSheet Method

Parameters

Return Value

Reference

SheetResourcesImportXlsSheet Method