Cmdlet
ConvertTo-OfficePdfExcel
Extracts detected PDF tables into an editable Excel workbook.
Syntax
ConvertTo-OfficePdfExcel
[-Force]
[-IgnorePermissionRestrictions]
[-Open]
[-Options <PdfTablesToExcelOptions>]
[-OutputPath] <String>
[-PassThruReport]
[-Password <String>]
[-Path] <String>
[<CommonParameters>]#Parameter set:
All Parameter SetsDescription
Uses OfficeIMO's logical table reconstruction, including typed numeric, Boolean, date, and percentage columns plus multi-page table continuation handling.
Examples
Convert detected PDF tables to Excel.
ConvertTo-OfficePdfExcel -Path .\Statement.pdf -OutputPath .\Statement.xlsxWrites an XLSX workbook with one table per detected logical table.
Parameters
- -Force SwitchParameter
- Overwrite an existing output file.
- -IgnorePermissionRestrictions SwitchParameter
- After successful authentication, explicitly ignore owner-imposed extraction restrictions.
- -Open SwitchParameter
- Open the converted workbook after saving.
- -Options PdfTablesToExcelOptions
- Advanced OfficeIMO PDF-table-to-Excel options.
- -OutputPath String
- Output XLSX path.
- -PassThruReport SwitchParameter
- Return the detailed table import report instead of file information.
- -Password String
- Password used to authenticate an encrypted PDF.
- -Path String
- Input PDF path.
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.