ConvertTo-OfficePdfExcel

Aliases: ConvertTo-PdfExcel

Namespace PSWriteOffice

Aliases

ConvertTo-PdfExcel

Inputs

System.String

Outputs

System.IO.FileInfo OfficeIMO.Excel.Pdf.PdfExcelTableImportReport

Source

Sources/PSWriteOffice/Cmdlets/Pdf/ConvertToOfficePdfExcelCommand.cs:22 Edit on GitHub

Extracts detected PDF tables into an editable Excel workbook.

Remarks

Uses OfficeIMO's logical table reconstruction, including typed numeric, Boolean, date, and percentage columns plus multi-page table continuation handling.

Examples

Authored help example

Convert detected PDF tables to Excel.

PS>


ConvertTo-OfficePdfExcel -Path .\Statement.pdf -OutputPath .\Statement.xlsx

Writes an XLSX workbook with one table per detected logical table.

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.

Syntax

ConvertTo-OfficePdfExcel [-Force] [-IgnorePermissionRestrictions] [-Open] [-Options <PdfExcelTableImportOptions>] -OutputPath <String> [-PassThruReport] [-Password <String>] -Path <String> [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

Force SwitchParameter optionalposition: namedpipeline: False: Overwrite an existing output file.
IgnorePermissionRestrictions SwitchParameter optionalposition: namedpipeline: False: After successful authentication, explicitly ignore owner-imposed extraction restrictions.
Open SwitchParameter optionalposition: namedpipeline: False: Open the converted workbook after saving.
Options PdfExcelTableImportOptions optionalposition: namedpipeline: False: Advanced OfficeIMO PDF-table-to-Excel options.
OutputPath String requiredposition: 1pipeline: Falsealiases: OutPath: Output XLSX path.
PassThruReport SwitchParameter optionalposition: namedpipeline: False: Return the detailed table import report instead of file information.
Password String optionalposition: namedpipeline: False: Password used to authenticate an encrypted PDF.
Path String requiredposition: 0pipeline: True (ByValue)aliases: FilePath: Input PDF path.

Outputs

System.IO.FileInfo, OfficeIMO.Excel.Pdf.PdfExcelTableImportReport