Connectors Reference

Excel Online (OneDrive)

Excel Online (OneDrive) connection provider lets you work with Excel files stored in OneDrive. This connection provider only supports personal (MSA) accounts.

 

Status: Preview

Tier: Standard

Version: 1.0

 

Actions:

Name

Summary

TestConnection ()

 

CreateTable ([internal]string source, [internal]string drive, string file, TableToCreate table)

Create table

CreateIdColumn ([internal]string source, [internal]string drive, string file, string table, [Optional]string idColumn)

Add a key column to a table

ODataStyleGetItems ([internal]string source, [internal]string drive, string file, string table, [advanced][Optional]string $filter, [advanced][Optional]string $orderby, [advanced][Optional]integer $top, [advanced][Optional]integer $skip)

List rows present in a table

ODataStylePostItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, Item item)

Update or insert a row

GetItems ([internal]string source, [internal]string drive, string file, string table, [advanced][Optional]string $filter, [advanced][Optional]string $orderby, [advanced][Optional]integer $top, [advanced][Optional]integer $skip)

List rows present in a table

PostItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, Item item)

Update or insert a row

ODataStyleGetItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, string id)

Get a row

ODataStyleDeleteItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, string id)

Delete a row

GetItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, string id)

Get a row

DeleteItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, string id)

Delete a row

GetSources ([internal][Optional]string $top)

Get sources

GetDrives ([internal]string source, [internal][Optional]string $select)

Get drives

ListRootFolder ([internal]string source, [internal]string drive)

List the root folder

ListFolder ([internal]string source, [internal]string drive, string id)

List blobs under a given folder

GetAllWorksheets ([internal]string source, [internal]string drive, string file)

Get worksheets

CreateWorksheet ([internal]string source, [internal]string drive, string file, CreateWorksheetParameterBody body)

Create worksheet

GetTables ([internal]string source, [internal]string drive, string file, [internal][Optional]string $select)

Get tables

GetTable ([internal]string source, [internal]string drive, string file, string table)

Get metadata of a table

GetColumns ([internal]string source, [internal]string drive, string file, string table)

Get table columns

AddRow ([internal]string source, [internal]string drive, string file, string table, Item item)

Add a row into a table

 

Triggers:

Name

Summary

 

Objects:

Name

Summary

AddRowResponse

 

BlobMetadata

 

CreateWorksheetParameterBody

 

GetAllWorksheetsResponse

 

GetColumnsResponse

 

GetDrivesResponse

 

GetSourcesResponse

 

GetTablesResponse

 

Item

 

ItemsList

 

Object

 

TableCapabilitiesMetadata

 

TableFilterRestrictionsMetadata

 

TableMetadata

 

TableSelectRestrictionsMetadata

 

TableSortRestrictionsMetadata

 

TableToCreate

 

WorksheetMetadata

 

 

Actions:

TestConnection

Summary:

Description:

 

Syntax:

ExcelOnline(OneDrive).TestConnection ()

 

Returns:

 

CreateTable

Summary: Create table

Description: Create a new table in the Excel workbook.

 

Syntax:

ExcelOnline(OneDrive).CreateTable ([internal]string source, [internal]string drive, string file, TableToCreate table)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

table

TableToCreate

 

Table to create.

True

 

Returns:

          Type:TableMetadata

          Description: Table metadata

 

CreateIdColumn

Summary: Add a key column to a table

Description: Add a key column to an Excel table.

 

Syntax:

ExcelOnline(OneDrive).CreateIdColumn ([internal]string source, [internal]string drive, string file, string table, [Optional]string idColumn)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

GetTables

idColumn

string

(Key Column)

Provide the key column name.

False

 

Returns:

 

ODataStyleGetItems

Summary: List rows present in a table

Description: List rows present in a table.

 

Syntax:

ExcelOnline(OneDrive).ODataStyleGetItems ([internal]string source, [internal]string drive, string file, string table, [advanced][Optional]string $filter, [advanced][Optional]string $orderby, [advanced][Optional]integer $top, [advanced][Optional]integer $skip)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required)

True

drive

string

(Document Library)

Select a document library from the drop-down.

True

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

$filter

string

(Filter Query)

An ODATA filter query to restrict the entries returned.

False

$orderby

string

(Order By)

An ODATA orderBy query for specifying the order of entries.

False

$top

integer(int32)

(Top Count)

Total number of entries to retrieve (default = all).

False

$skip

integer(int32)

(Skip Count)

The number of entries to skip (default = 0).

False

 

Returns:

          Type:ItemsList

          Description: List of Items

 

ODataStylePostItem

Summary: Update or insert a row

Description: Update or insert a row using a key column.

 

Syntax:

ExcelOnline(OneDrive).ODataStylePostItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, Item item)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required)

True

drive

string

(Document Library)

Select a document library from the drop-down.

True

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

idColumn

string

(Key Column)

Select a column from the drop-down.

True

item

Item

 

Table item entity

True

 

Returns:

          Type:Item

          Description: Table item entity

 

GetItems

Summary: List rows present in a table

Description: List rows present in a table.

 

Syntax:

ExcelOnline(OneDrive).GetItems ([internal]string source, [internal]string drive, string file, string table, [advanced][Optional]string $filter, [advanced][Optional]string $orderby, [advanced][Optional]integer $top, [advanced][Optional]integer $skip)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required)

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

GetTables

$filter

string

(Filter Query)

An ODATA filter query to restrict the entries returned.

False

$orderby

string

(Order By)

An ODATA orderBy query for specifying the order of entries.

False

$top

integer(int32)

(Top Count)

Total number of entries to retrieve (default = all).

False

$skip

integer(int32)

(Skip Count)

The number of entries to skip (default = 0).

False

 

Returns:

          Type:ItemsList

          Description: List of Items

 

PostItem

Summary: Update or insert a row

Description: Update or insert a row using a key column.

 

Syntax:

ExcelOnline(OneDrive).PostItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, Item item)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required)

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

GetTables

idColumn

string

(Key Column)

Select a column from the drop-down.

True

GetColumns

item

Item

 

Table item entity

True

 

Returns:

          Type:Item

          Description: Table item entity

 

ODataStyleGetItem

Summary: Get a row

Description: Get a row using a key column.

 

Syntax:

ExcelOnline(OneDrive).ODataStyleGetItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, string id)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required)

True

drive

string

(Document Library)

Select a document library from the drop-down.

True

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

idColumn

string

(Key Column)

Select a column from the drop-down.

True

id

string

(Key Value)

Enter the key value.

True

 

Returns:

          Type:Item

          Description: Table item entity

 

ODataStyleDeleteItem

Summary: Delete a row

Description: Delete a row using a key column.

 

Syntax:

ExcelOnline(OneDrive).ODataStyleDeleteItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, string id)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required)

True

drive

string

(Document Library)

Select a document library from the drop-down.

True

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

idColumn

string

(Key Column)

Select a column from the drop-down.

True

id

string

(Key Value)

Enter the key value.

True

 

Returns:

 

GetItem

Summary: Get a row

Description: Get a row using a key column.

 

Syntax:

ExcelOnline(OneDrive).GetItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, string id)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required)

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

GetTables

idColumn

string

(Key Column)

Select a column from the drop-down.

True

GetColumns

id

string

(Key Value)

Enter the key value.

True

 

Returns:

          Type:Item

          Description: Table item entity

 

DeleteItem

Summary: Delete a row

Description: Delete a row using a key column.

 

Syntax:

ExcelOnline(OneDrive).DeleteItem ([internal]string source, [internal]string drive, string file, string table, string idColumn, string id)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:             - "me"             - "SharePoint Site URL"             - "users/someone's UPN"             - "groups/group Id"             - "sites/SharePoint Site URL:/teams/team name:" (the colons are required)

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

GetTables

idColumn

string

(Key Column)

Select a column from the drop-down.

True

GetColumns

id

string

(Key Value)

Enter the key value.

True

 

Returns:

 

GetSources

Summary: Get sources

Description: Get a list of sources.

 

Syntax:

ExcelOnline(OneDrive).GetSources ([internal][Optional]string $top)

 

Parameters:

Name

Type

Summary

Required

Related Action

$top

string

(Top)

Top.

False

 

Returns:

          Type:GetSourcesResponse

 

GetDrives

Summary: Get drives

Description: Get a list of drives.

 

Syntax:

ExcelOnline(OneDrive).GetDrives ([internal]string source, [internal][Optional]string $select)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:               - "me"               - "SharePoint Site URL"               - "users/someone's UPN"               - "groups/group Id"               - "sites/SharePoint Site URL:/teams/team name:" (colons are required).

True

GetSources

$select

string

(Select)

Select.

False

 

Returns:

          Type:GetDrivesResponse

 

ListRootFolder

Summary: List the root folder

Description: List the root folder.

 

Syntax:

ExcelOnline(OneDrive).ListRootFolder ([internal]string source, [internal]string drive)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:               - "me"               - "SharePoint Site URL"               - "users/someone's UPN"               - "groups/group Id"               - "sites/SharePoint Site URL:/teams/team name:" (colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

 

Returns:

          Type:array of (BlobMetadata)

 

ListFolder

Summary: List blobs under a given folder

Description: List blobs under a given folder.

 

Syntax:

ExcelOnline(OneDrive).ListFolder ([internal]string source, [internal]string drive, string id)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:               - "me"               - "SharePoint Site URL"               - "users/someone's UPN"               - "groups/group Id"               - "sites/SharePoint Site URL:/teams/team name:" (colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

id

string

(Folder)

Folder Id.

True

 

Returns:

          Type:array of (BlobMetadata)

 

GetAllWorksheets

Summary: Get worksheets

Description: Get a list of worksheets in the Excel workbook.

 

Syntax:

ExcelOnline(OneDrive).GetAllWorksheets ([internal]string source, [internal]string drive, string file)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:               - "me"               - "SharePoint Site URL"               - "users/someone's UPN"               - "groups/group Id"               - "sites/SharePoint Site URL:/teams/team name:" (colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

 

Returns:

          Type:GetAllWorksheetsResponse

 

CreateWorksheet

Summary: Create worksheet

Description: Create a new worksheet in the Excel workbook.

 

Syntax:

ExcelOnline(OneDrive).CreateWorksheet ([internal]string source, [internal]string drive, string file, CreateWorksheetParameterBody body)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:               - "me"               - "SharePoint Site URL"               - "users/someone's UPN"               - "groups/group Id"               - "sites/SharePoint Site URL:/teams/team name:" (colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

body

CreateWorksheetParameterBody

 

 

True

 

Returns:

          Type:WorksheetMetadata

 

GetTables

Summary: Get tables

Description: Get a list of tables in the Excel workbook.

 

Syntax:

ExcelOnline(OneDrive).GetTables ([internal]string source, [internal]string drive, string file, [internal][Optional]string $select)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:               - "me"               - "SharePoint Site URL"               - "users/someone's UPN"               - "groups/group Id"               - "sites/SharePoint Site URL:/teams/team name:" (colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

$select

string

(Select)

Select.

False

 

Returns:

          Type:GetTablesResponse

 

GetTable

Summary: Get metadata of a table

Description: Get metadata of a table.

 

Syntax:

ExcelOnline(OneDrive).GetTable ([internal]string source, [internal]string drive, string file, string table)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:               - "me"               - "SharePoint Site URL"               - "users/someone's UPN"               - "groups/group Id"               - "sites/SharePoint Site URL:/teams/team name:" (colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

GetTables

 

Returns:

          Type:TableMetadata

          Description: Table metadata

 

GetColumns

Summary: Get table columns

Description: Get table columns.

 

Syntax:

ExcelOnline(OneDrive).GetColumns ([internal]string source, [internal]string drive, string file, string table)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:               - "me"               - "SharePoint Site URL"               - "users/someone's UPN"               - "groups/group Id"               - "sites/SharePoint Site URL:/teams/team name:" (colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

GetTables

 

Returns:

          Type:GetColumnsResponse

 

AddRow

Summary: Add a row into a table

Description: Add a new row into the Excel table.

 

Syntax:

ExcelOnline(OneDrive).AddRow ([internal]string source, [internal]string drive, string file, string table, Item item)

 

Parameters:

Name

Type

Summary

Required

Related Action

source

string

(Location)

Select from the drop-down or specify one of the following:               - "me"               - "SharePoint Site URL"               - "users/someone's UPN"               - "groups/group Id"               - "sites/SharePoint Site URL:/teams/team name:" (colons are required).

True

GetSources

drive

string

(Document Library)

Select a document library from the drop-down.

True

GetDrives

file

string

(File)

Select an Excel file through File Browse.

True

table

string

(Table)

Select a table from the drop-down.

True

GetTables

item

Item

 

Table item entity

True

 

Returns:

          Type:AddRowResponse

 


 

AddRowResponse

Summary:

Description:

 

          Properties:

Name

Type

Summary


 

BlobMetadata

Summary:

Description:

 

          Properties:

Name

Type

Summary

Id

string

 

The unique id of the file or folder.

Name

string

 

The name of the file or folder.

DisplayName

string

 

The display name of the file or folder.

Path

string

 

The path of the file or folder.

MediaType

string

 

The media type of the file or folder.

IsFolder

boolean

 

A boolean value (true, false) to indicate whether or not the blob is a folder.


 

CreateWorksheetParameterBody

Summary:

Description:

 

          Properties:

Name

Type

Summary

name

string

Name

Worksheet name.


 

GetAllWorksheetsResponse

Summary:

Description:

 

          Properties:

Name

Type

Summary

value

array of (WorksheetMetadata)

 

 


 

GetColumnsResponse

Summary:

Description:

 

          Properties:

Name

Type

Summary

value

array of (ValueItem)

 

 

 

ValueItem

Summary:

Description:

 

          Properties:

Name

Type

Summary

name

string

Name

Column name.

 


 

GetDrivesResponse

Summary:

Description:

 

          Properties:

Name

Type

Summary

value

array of (ValueItem)

 

 

 

ValueItem

Summary:

Description:

 

          Properties:

Name

Type

Summary

id

string

Id

Drive Id.

name

string

Name

Drive name.

 


 

GetSourcesResponse

Summary:

Description:

 

          Properties:

Name

Type

Summary

value

array of (ValueItem)

 

 

 

ValueItem

Summary:

Description:

 

          Properties:

Name

Type

Summary

id

string

Id

Id.

displayName

string

Name

Name.

 


 

GetTablesResponse

Summary:

Description:

 

          Properties:

Name

Type

Summary

value

array of (ValueItem)

 

 

 

ValueItem

Summary:

Description:

 

          Properties:

Name

Type

Summary

id

string

Id

Table Id.

name

string

Name

Table name.

showBandedColumns

boolean

Show banded columns

Show banded columns.  Values: [, true, false]

highlightFirstColumn

boolean

Highlight first column

Highlight first column.  Values: [, true, false]

highlightLastColumn

boolean

Highlight last column

Highlight last column.  Values: [, true, false]

showBandedRows

boolean

Show banded rows

Show banded rows.  Values: [, true, false]

showFilterButton

boolean

Show filter button

Show filter button.  Values: [, true, false]

showHeaders

boolean

Show headers

Show headers.  Values: [, true, false]

showTotals

boolean

Show totals

Show totals.  Values: [, true, false]

style

string

Style

Table style.

 


 

Item

Summary:

Description: Table item entity

 

          Properties:

Name

Type

Summary

dynamicProperties

DynamicProperties

 

 

ItemInternalId

string

 

Table item internal id

 

DynamicProperties

Summary:

Description:

 

          Properties:

Name

Type

Summary

 


 

ItemsList

Summary:

Description: List of Items

 

          Properties:

Name

Type

Summary

value

array of (Item)

 

List of Items


 

Object

Summary:

Description:

 

          Properties:

Name

Type

Summary


 

TableCapabilitiesMetadata

Summary:

Description: Metadata for a table (capabilities)

 

          Properties:

Name

Type

Summary

sortRestrictions

TableSortRestrictionsMetadata

 

Metadata for a table (sort restrictions)

filterRestrictions

TableFilterRestrictionsMetadata

 

Metadata for a table (filter restrictions)

selectRestrictions

TableSelectRestrictionsMetadata

 

Metadata for a table (select restrictions)

isOnlyServerPagable

boolean

 

Server paging restrictions

filterFunctionSupport

array of (string)

 

List of supported filter capabilities

serverPagingOptions

array of (string)

 

List of supported server-driven paging capabilities


 

TableFilterRestrictionsMetadata

Summary:

Description: Metadata for a table (filter restrictions)

 

          Properties:

Name

Type

Summary

filterable

boolean

 

Indicates whether this table has filterable columns

nonFilterableProperties

array of (string)

 

List of non filterable properties

requiredProperties

array of (string)

 

List of required properties


 

TableMetadata

Summary:

Description: Table metadata

 

          Properties:

Name

Type

Summary

name

string

 

Table name

title

string

 

Table title

x-ms-permission

string

 

Table permission

x-ms-capabilities

TableCapabilitiesMetadata

 

Metadata for a table (capabilities)

schema

Object

 

 

referencedEntities

Object

 

 

webUrl

string

 

Url link


 

TableSelectRestrictionsMetadata

Summary:

Description: Metadata for a table (select restrictions)

 

          Properties:

Name

Type

Summary

selectable

boolean

 

Indicates whether this table has selectable columns


 

TableSortRestrictionsMetadata

Summary:

Description: Metadata for a table (sort restrictions)

 

          Properties:

Name

Type

Summary

sortable

boolean

 

Indicates whether this table has sortable columns

unsortableProperties

array of (string)

 

List of unsortable properties

ascendingOnlyProperties

array of (string)

 

List of properties which support ascending order only


 

TableToCreate

Summary:

Description: Table to create.

 

          Properties:

Name

Type

Summary

TableName

string

Table name

Enter the Excel table name.

Range

string

Table range

Enter the table address using A1 notation.

ColumnsNames

string

Columns names

Enter the columns names separated by ';' or ','.


 

WorksheetMetadata

Summary:

Description:

 

          Properties:

Name

Type

Summary

id

string

Id

Worksheet Id.

name

string

Name

Worksheet name.

position

integer(int32)

Position

Worksheet position.

visibility

string

Visibility

Worksheet visibility.