Python Connector for Microsoft Excel

Connection parameters - Python Connector for Microsoft Excel

Connection parameters

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

Parameter Description

Database

The path to the workbook

ReadOnly

Enables a read-only multi-user mode.

By default, workbooks can only be accessed by a single user. The connector implements a read-only multi-user mode to enable several users to read data from a workbook simultaneously.

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

DescribeAmount

The number of rows in a worksheet that will used to create a list of columns in a result set. The default value is 25.

ExclusiveLock

Enforces a single-user mode for a workbook. This parameter overrides the ReadOnly parameter.

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

HeaderRow

Specifies whether the values from the first row in a worksheet will be used as column names in a result set.

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

HideRowId

Specifies whether to exclude the ROWID pseudo column from a result set.

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

IncludeEmptyRows

Specifies whether to include empty rows from a worksheet into a result set.

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

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-2026 Devart. All Rights Reserved. Request Support Python Connectors Forum Provide Feedback