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

New-OfficeExcelTestOptions

Module
PSWriteOffice
Inputs
None
Source
NewOfficeExcelTestOptionsCommand.cs:27 Edit on GitHub

Creates Excel checks for Test-OfficeDocument: capability preflight and package validation.

Syntax

New-OfficeExcelTestOptions
[-Capability <ExcelPreflightCapability[]>]
[-IncludeFeatures]
[-IncludeRepairHints]
[-NoOpenXmlValidation]
[<CommonParameters>]
#
Parameter set: Default

Guides & Samples

Authored walkthroughs and practical samples linked to this command.

  • Choose a PSWriteOffice Workflow Guide

    Decide between authoring, editing, inspection, conversion, and normalized Reader extraction. Includes examples and cmdlet links.

  • Automate Excel Workbooks Guide

    Build, inspect, validate, compare, repair, and publish workbook workflows from PowerShell. Includes examples and cmdlet links.

  • Validate and Repair Excel Workbooks Guide

    Preflight workbook operations, test integrity and accessibility, diagnose package state, and apply deliberate repairs.

Examples

Check that formulas can be calculated

Test-OfficeDocument -Path .\Finance\Budget-2027.xlsx -Options (New-OfficeExcelTestOptions -Capability CalculateFormulas)

Tests whether OfficeIMO can calculate the formulas in a workbook.

Preflight templates before a report run

$checks = New-OfficeExcelTestOptions -Capability BindTemplate, ExportPdfReport -IncludeRepairHints
Get-ChildItem -Path .\Templates -Filter *.xltx |
    Test-OfficeDocument -Options $checks

Checks each template for template binding and PDF export and includes repair hints for anything that fails.

Parameters

-Capability ExcelPreflightCapability[] optional
Capabilities to evaluate or enforce. Defaults to all capabilities.
Possible values: ReadWorkbookData, EditCellValues, EditWorkbookStructure, UseCachedFormulaValues, CalculateFormulas, BindTemplate, ExportPdfReport
-IncludeFeatures SwitchParameter optional
Include discovered feature rows in object output.
-IncludeRepairHints SwitchParameter optional
Include actionable OfficeIMO repair hints for blocked capabilities.
-NoOpenXmlValidation SwitchParameter optional
Skips native Open XML schema validation while retaining other workbook checks.

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.