New-OfficePdfExcelImportOptions

Namespace PSWriteOffice

Inputs

None

Outputs

OfficeIMO.Excel.Pdf.PdfExcelTableImportOptions

Source

Sources/PSWriteOffice/Cmdlets/Excel/NewOfficePdfExcelImportOptionsCommand.cs:17 Edit on GitHub

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

Remarks

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

Examples

Authored help example

Import PDF tables with typed columns and filters.

PS>


$options = New-OfficePdfExcelImportOptions -IncludeAutoFilter -AutoFitColumns -ConvertNumericColumns -ConvertDateTimeColumns
            ConvertTo-OfficePdfExcel -Path .\Tables.pdf -OutputPath .\Tables.xlsx -Options $options

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

New-OfficePdfExcelImportOptions [-AutoFitColumns] [-ContinuationGeometryTolerancePoints <Double>] [-ConvertBooleanColumns] [-ConvertDateTimeColumns] [-ConvertNumericColumns] [-ConvertPercentageColumns] [-EmptyWorkbookSheetName <String>] [-IncludeAutoFilter] [-MaximumContinuationSegments <Int32>] [-MaxRows <Int32>] [-MergePageContinuations] [-NumericCulture <String>] [-SheetNamePrefix <String>] [-SuppressRepeatedBodyHeaderRows] [-TableNamePrefix <String>] [-TableStyle <TableStyleLight1>] [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

AutoFitColumns SwitchParameter optionalposition: namedpipeline: False: Auto-fit worksheet columns.
ContinuationGeometryTolerancePoints Double optionalposition: namedpipeline: False: Geometry tolerance in PDF points for page continuations.
ConvertBooleanColumns SwitchParameter optionalposition: namedpipeline: False: Convert consistently boolean columns.
ConvertDateTimeColumns SwitchParameter optionalposition: namedpipeline: False: Convert unambiguous date columns.
ConvertNumericColumns SwitchParameter optionalposition: namedpipeline: False: Convert consistently numeric columns.
ConvertPercentageColumns SwitchParameter optionalposition: namedpipeline: False: Convert percentage columns to fractional numbers.
EmptyWorkbookSheetName String optionalposition: namedpipeline: False: Worksheet name used when no tables are detected.
IncludeAutoFilter SwitchParameter optionalposition: namedpipeline: False: Add table-scoped AutoFilters.
MaximumContinuationSegments Int32 optionalposition: namedpipeline: False: Maximum table segments merged into one table.
MaxRows Int32 optionalposition: namedpipeline: False: Maximum body rows imported per detected table; zero means unlimited.
MergePageContinuations SwitchParameter optionalposition: namedpipeline: False: Merge compatible table segments across pages.
NumericCulture String optionalposition: namedpipeline: False: Culture name used for numeric parsing, such as en-US.
SheetNamePrefix String optionalposition: namedpipeline: False: Prefix for generated worksheet names.
SuppressRepeatedBodyHeaderRows SwitchParameter optionalposition: namedpipeline: False: Suppress repeated body header rows in merged segments.
TableNamePrefix String optionalposition: namedpipeline: False: Prefix for generated Excel table names.
TableStyle ExcelTableStyle optionalposition: namedpipeline: Falsevalues: 60: 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

Outputs

OfficeIMO.Excel.Pdf.PdfExcelTableImportOptions