MCP Server for Microsoft Excel Online

Build 25.0.9440

IncludePrimaryKey

Controls whether the driver includes an auto-generated primary key column in the table definition.

Data Type

bool

Default Value

true

Remarks

When set to True (default), the driver adds a primary key column (id) to each table. The column name can be customized using the PrimaryKeyIdentifier property. When set to False, the driver omits the auto-generated primary key column entirely and returns only the columns defined in the source data.

Disabling this option will impact performance for UPDATE and DELETE operations, as the driver must search all matching rows instead of directly relying on the primary key column.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440