Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, PowerShell module, CLI, Studio and browser tools 613 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/
Cmdlet

Set-OfficeExcelPrintTitles

Aliases: ExcelPrintTitles
Module PSWriteOffice
Aliases
ExcelPrintTitles
Inputs
OfficeIMO.Excel.ExcelDocument
Source
SetOfficeExcelPrintTitlesCommand.cs:21 Edit on GitHub

Sets or clears repeating print title rows and columns for a worksheet.

Syntax

Set-OfficeExcelPrintTitles [-Clear] [-FirstColumn <Int32>] [-FirstRow <Int32>] [-LastColumn <Int32>] [-LastRow <Int32>] [-PassThru] [-Sheet <String>] [-SheetIndex <Int32>] [<CommonParameters>]
#
Parameter set: Context
Set-OfficeExcelPrintTitles [-Clear] [-FirstColumn <Int32>] [-FirstRow <Int32>] [-LastColumn <Int32>] [-LastRow <Int32>] [-PassThru] [-Path] <String> [-Sheet <String>] [-SheetIndex <Int32>] [<CommonParameters>]
#
Parameter set: Path
Set-OfficeExcelPrintTitles [-Clear] -Document <ExcelDocument> [-FirstColumn <Int32>] [-FirstRow <Int32>] [-LastColumn <Int32>] [-LastRow <Int32>] [-PassThru] [-Sheet <String>] [-SheetIndex <Int32>] [<CommonParameters>]
#
Parameter set: Document

Guides & Samples

Authored walkthroughs and practical samples linked to this command.

  • Project delivery and milestones Sample

    Turn dated milestones into an editable register and a Word/PDF review with completed counts, overdue work and named recovery actions.

  • Budget and forecast review Sample

    Reconcile annual budget, actual spending and forecast in an editable workbook, then produce a Word/PDF review with owner decisions for overspend exceptions.

Examples

Authored help example

Repeat report headers on every printed page.

$proof = @(
    Set-OfficeExcelPrintTitles -Path .\Report.xlsx -Sheet Data -FirstRow 1 -LastRow 1 -FirstColumn 1 -LastColumn 1
    Get-OfficeExcelSummary -Path .\Report.xlsx |
        Select-Object -Property SheetCount, TableCount
)
$proof

Stores Excel print titles for the Data worksheet and then reads back workbook structure as a quick proof step.

Parameters

-Clear SwitchParameter optional
Clear existing print titles for the worksheet.
-FirstColumn Int32 optional
First 1-based column to repeat.
-FirstRow Int32 optional
First 1-based row to repeat.
-LastColumn Int32 optional
Last 1-based column to repeat.
-LastRow Int32 optional
Last 1-based row to repeat.
-PassThru SwitchParameter optional
Emit the worksheet after setting print titles.
-Sheet String optionalaliases: WorksheetName
Worksheet name. Defaults to the current sheet inside an ExcelSheet block.
-SheetIndex Int32 optional
Worksheet index when using a workbook object or path.
-Path String requiredposition: 0aliases: FilePath, InputPathsets: Path
Workbook path to update.
-Document ExcelDocument requiredpipeline: True (ByValue)sets: Document
Workbook to update outside the DSL context.

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.