Cmdlet
Export-OfficeExcelRangeImage
Exports one worksheet range as an image file.
Syntax
Export-OfficeExcelRangeImage
[-Force]
[-Format <OfficeImageExportFormat>]
[-Options <ExcelImageExportOptions>]
[[-OutputPath] <String>]
[-PassThru]
[-Path] <String>
-Range <String>
-WorksheetName <String>
[<CommonParameters>]#Parameter set:
PathExport-OfficeExcelRangeImage
-Document <ExcelDocument>
[-Force]
[-Format <OfficeImageExportFormat>]
[-Options <ExcelImageExportOptions>]
[[-OutputPath] <String>]
[-PassThru]
-Range <String>
-WorksheetName <String>
[<CommonParameters>]#Parameter set:
DocumentExamples
Export a report range for use in an email.
Export-OfficeExcelRangeImage -Path .\Report.xlsx -WorksheetName Summary -Range A1:H20 -OutputPath .\summary.pngParameters
- -Force SwitchParameter
- Replace an existing destination file.
- -Format OfficeImageExportFormat
- Output image format.
- Possible values:
Png,Svg,Jpeg,Tiff,Webp,Bmp,Pbm,Tga,Icon - -Options ExcelImageExportOptions
- Optional rendering, size, font, and diagnostic policy settings.
- -OutputPath String
- Optional destination image file. When omitted, returns the in-memory image result only.
- -PassThru SwitchParameter
- Emit the structured image export result when a destination path is used.
- -Path String
- Path to the workbook.
- -Range String
- A1 range address to export.
- -WorksheetName String
- Name of the worksheet containing the range.
- -Document ExcelDocument
- Open workbook instance.
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.