Controls whether to include columns that appear before the specified Excel range.

Syntax

Connect-ExcelOnline -IncludePreRangeColumns bool

Data Type

bool

Default Value

true

Remarks

If true, includes all columns from column A up to the start of the specified range. Otherwise, only includes columns within the specified range.

Example, for a range 'C1:E5':

• If true: Shows columns A, B, C, D, and E
• If false: Shows only columns C, D, and E