Specifies the maximum number of characters that a cell can contain before its value is truncated.

Syntax

Connect-CSV -MaxCellLength int

Data Type

int

Default Value

-1

Remarks

When this property is set to a positive integer, the cmdlet truncates any cell value that exceeds the specified number of characters.

When set to -1, there is no limit on cell length.

This property is useful for preventing excessively long text values from impacting performance or memory usage when reading large files.