Python Connector for Microsoft Excel Online

Connection parameters - Python Connector for Microsoft Excel Online

Connection parameters

The following table describes the Microsoft Excel Online connection parameters you can use in the connect() module method.

Parameter Description

WorkbookId

The workbook ID.

Use the getworkbook() method to obtain the workbook ID.

RefreshToken

The refresh token.

Follow the instructions in Using the module to obtain a refresh token.

Proxy parameters

ProxyHostName

The hostname or IP address of the proxy server

ProxyPort

The proxy port

ProxyUserName

The username for proxy authentication

ProxyPassword

The password for proxy authentication

Other parameters

HeaderAsColumnName

Specifies whether to use the first row of a spreadsheet to identify the column names. By default, the standard A-Z column names are used.

The possible values are True and False. The default value is False.

MinColumnCount

The minimum number of columns in a spreadsheet. This parameter is applied when HeaderAsColumnName is False.

The default value is 26 (A-Z range).

SheetTables

Specifies whether tables in a spreadsheet will be treated as separate objects.

The possible values are True and False. The default value is False.

MaxCellLength

The maximum number of characters in a cell.

The default value is 4000 characters.

PoolId

The ID of a connection pool that will be used for a particular connection

DisablePooling

Disables connection pooling for a particular connection.

The possible values are True and False. The default value is False.

© 2022-2025 Devart. All Rights Reserved. Request Support Python Connectors Forum Provide Feedback