Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, PowerShell module, CLI, Studio and browser tools 700 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

Close-OfficeExcel

Module
PSWriteOffice
Inputs
OfficeIMO.Excel.ExcelDocument
Source
CloseOfficeExcelCommand.cs:30 Edit on GitHub

Closes a live Excel workbook without saving pending changes.

Syntax

Close-OfficeExcel
[-Document] <ExcelDocument>
[<CommonParameters>]
#
Parameter set: Default

Description

Use Save-OfficeExcel before closing to retain changes. Workbooks with SaveOnDispose are rejected so disposal cannot publish a file.

Guides & Samples

Authored walkthroughs and practical samples linked to this command.

  • Pipeline, Object, and DSL Workflows Guide

    Choose the shortest PSWriteOffice surface for quick exports, incremental composition, complete document authoring, or existing-file updates.

  • Update Existing Excel Workbooks Guide

    Replace values, edit rows, append table data, and make targeted workbook changes without rebuilding every sheet.

  • Quick Start Guide

    Create your first Word document, Excel workbook, and PowerPoint presentation with OfficeIMO in minutes. Includes examples and API links.

Examples

Save edits explicitly, then close.

$workbook | Save-OfficeExcel
$workbook | Close-OfficeExcel

Close a workbook without saving

$book = Open-OfficeExcel -Path .\Reports\Q3-Sales.xlsx -ReadOnly
Close-OfficeExcel -Document $book

Releases a workbook that was only read; nothing is written to disk.

Always close after reading

$book = Open-OfficeExcel -Path .\Finance\Purchase-Requests.xlsx -ReadOnly
try {
    Import-OfficeExcel -Document $book -Table Requests | Where-Object Status -eq 'Awaiting approval'
} finally {
    Close-OfficeExcel -Document $book
}

Reads the open purchase requests and closes the workbook in a finally block, so the file is released even if the filter fails.

Parameters

-Document ExcelDocument requiredposition: 0pipeline: True (ByValue)
Explicit-persistence workbook to close.

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.