Project

PSWriteOffice

PowerShell document automation across OfficeIMO's document, spreadsheet, presentation, PDF, Project, Access, EPUB, invoicing, and conversion engines.

Stars 654

Forks 82

Open issues 1

Total downloads 4,320,051

Release OfficeIMO-v3.5.3

Language: C# Updated: 2026-11-03

Cmdlet

Invoke-OfficeExcelAutoFit

Aliases: ExcelAutoFit

Module: PSWriteOffice
Aliases: ExcelAutoFit
Inputs: OfficeIMO.Excel.ExcelDocument
Source: InvokeOfficeExcelAutoFitCommand.cs:19 Edit on GitHub

Automatically fits Excel row heights and/or column widths.

Syntax

Invoke-OfficeExcelAutoFit
[-All]
[-Column <Int32[]>]
[-Columns]
[-Row <Int32[]>]
[-Rows]
[<CommonParameters>]

Parameter set: Context

Invoke-OfficeExcelAutoFit
[-All]
[-Column <Int32[]>]
[-Columns]
-Document <ExcelDocument>
[-Row <Int32[]>]
[-Rows]
[-Sheet <String>]
[-SheetIndex <Int32>]
[<CommonParameters>]

Parameter set: Document

Description

Targets the current worksheet context or a worksheet on a supplied document.

Examples

Auto-fit columns in the current DSL sheet.

ExcelSheet 'Data' { Invoke-OfficeExcelAutoFit -Columns }

Adjusts column widths for the active sheet.

Parameters

-All SwitchParameter optional: Auto-fit both rows and columns.
-Column Int32[] optional: Auto-fit specific column indexes (1-based).
-Columns SwitchParameter optional: Auto-fit all columns.
-Row Int32[] optional: Auto-fit specific row indexes (1-based).
-Rows SwitchParameter optional: Auto-fit all rows.
-Document ExcelDocument requiredpipeline: True (ByValue)sets: Document: Workbook to operate on outside the DSL context.
-Sheet String optionalsets: Document: Worksheet name when using Document.
-SheetIndex Int32 optionalsets: Document: Worksheet index (0-based) when using Document.

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.