Cmdlet

New-OfficePdfExcelOptions

Module: PSWriteOffice
Inputs: None
Outputs: OfficeIMO.Pdf.Excel.PdfExcelExportOptions
Source: NewOfficePdfExcelOptionsCommand.cs:19 Edit on GitHub

Creates discoverable PDF-table-to-Excel reconstruction settings.

Syntax

New-OfficePdfExcelOptions
[-ContinuationGeometryTolerance <OfficeLength>]
[-Culture <CultureInfo>]
[-EmptyWorkbookSheetName <String>]
[-KeepRepeatedHeaderRows]
[-MaximumContinuationSegments <Int32>]
[-MaxRows <Int32>]
[-NoAutoFilter]
[-NoAutoFit]
[-NoBooleanConversion]
[-NoDateTimeConversion]
[-NoNumericConversion]
[-NoPageContinuationMerge]
[-NoPercentageConversion]
[-SheetNamePrefix <String>]
[-TableNamePrefix <String>]
[-TableStyle <ExcelTableStyle>]
[<CommonParameters>]

Parameter set: Default

Examples

Import PDF tables using British number and date parsing.

$options = New-OfficePdfExcelOptions -Culture en-GB
Convert-OfficeDocument -Path ./Tables.pdf -To Excel -OutputPath ./Tables.xlsx -Options $options

Keep values as text and disable fitted widths.

$options = New-OfficePdfExcelOptions -NoNumericConversion -NoDateTimeConversion -NoAutoFit
Convert-OfficeDocument -Path ./Tables.pdf -To Excel -OutputPath ./Text.xlsx -Options $options

Parameters

-ContinuationGeometryTolerance OfficeLength optional: Physical geometry tolerance for page continuations; bare numbers mean points.
-Culture CultureInfo optional: Culture used for numeric parsing; defaults to the current culture.
-EmptyWorkbookSheetName String optional: Worksheet name used when no tables are detected.
-KeepRepeatedHeaderRows SwitchParameter optional: Retain repeated body header rows in merged table segments.
-MaximumContinuationSegments Int32 optional: Maximum table segments merged into one table.
-MaxRows Int32 optional: Maximum body rows imported per detected table; zero means unlimited.
-NoAutoFilter SwitchParameter optional: Exclude table-scoped AutoFilters.
-NoAutoFit SwitchParameter optional: Keep native widths without fitting worksheet columns.
-NoBooleanConversion SwitchParameter optional: Keep boolean-looking values as text.
-NoDateTimeConversion SwitchParameter optional: Keep date-looking values as text.
-NoNumericConversion SwitchParameter optional: Keep numeric-looking values as text.
-NoPageContinuationMerge SwitchParameter optional: Keep table segments on separate worksheets instead of merging across pages.
-NoPercentageConversion SwitchParameter optional: Keep percentage values as text.
-SheetNamePrefix String optional: Prefix for generated worksheet names.
-TableNamePrefix String optional: Prefix for generated Excel table names.
-TableStyle ExcelTableStyle optional: Excel table style.; Possible values: TableStyleLight1, TableStyleLight2, TableStyleLight3, TableStyleLight4, TableStyleLight5, TableStyleLight6, TableStyleLight7, TableStyleLight8, TableStyleLight9, TableStyleLight10, TableStyleLight11, TableStyleLight12, TableStyleLight13, TableStyleLight14, TableStyleLight15, TableStyleLight16, TableStyleLight17, TableStyleLight18, TableStyleLight19, TableStyleLight20, TableStyleLight21, TableStyleMedium1, TableStyleMedium2, TableStyleMedium3, TableStyleMedium4, TableStyleMedium5, TableStyleMedium6, TableStyleMedium7, TableStyleMedium8, TableStyleMedium9, TableStyleMedium10, TableStyleMedium11, TableStyleMedium12, TableStyleMedium13, TableStyleMedium14, TableStyleMedium15, TableStyleMedium16, TableStyleMedium17, TableStyleMedium18, TableStyleMedium19, TableStyleMedium20, TableStyleMedium21, TableStyleMedium22, TableStyleMedium23, TableStyleMedium24, TableStyleMedium25, TableStyleMedium26, TableStyleMedium27, TableStyleMedium28, TableStyleDark1, TableStyleDark2, TableStyleDark3, TableStyleDark4, TableStyleDark5, TableStyleDark6, TableStyleDark7, TableStyleDark8, TableStyleDark9, TableStyleDark10, TableStyleDark11

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.