Specifies how the provider handles leading and trailing spaces in cell values.

Possible Values

Data Type

string

Default Value

"FALSE"

Remarks

This property controls whether spaces at the beginning and end of cell values are removed or retained when reading data. It applies to all cell values unless limited by the TrimQuotedValues property.

Possible values include:

• FALSE: Leading and trailing spaces are retained.
• TRUE: Both leading and trailing spaces are removed.
• LEADING: Only leading spaces are removed.
• TRAILING: Only trailing spaces are removed.

This property is useful for normalizing inconsistent spacing in text files during import.