Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/

API Reference

Class

PdfTablesToExcelOptions

Namespace OfficeIMO.Excel.Pdf
Assembly OfficeIMO.Excel.Pdf
Modifiers sealed

Options for extracting logical PDF tables into an Excel workbook.

Inheritance

  • Object
  • PdfTablesToExcelOptions

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Constructors

Properties

public PdfReadOptions ReadOptions { get; set; } #

Canonical semantic-read settings used when importing an opened PdfDocument. Null uses Default. This setting is ignored when the source is already an PdfDocumentReadResult.

public Int32 MaxRows { get; set; } #

Maximum body rows to import per detected table. Values less than or equal to zero import all rows.

public String SheetNamePrefix { get; set; } #

Worksheet name prefix used before the source page and table coordinates.

public String TableNamePrefix { get; set; } #

Excel table name prefix used before the source page and table coordinates.

public ExcelTableStyle TableStyle { get; set; } #

Excel table style applied to imported tables.

public Boolean IncludeAutoFilter { get; set; } #

When true, created Excel tables include a table-scoped AutoFilter.

public Boolean AutoFitColumns { get; set; } #

When true, worksheet columns are auto-fitted after the table is inserted.

public Boolean ConvertNumericColumns { get; set; } #

When true, detected numeric PDF table columns are written as numeric Excel cells when every non-empty value can be parsed.

public Boolean ConvertBooleanColumns { get; set; } #

When true, columns containing only invariant true/false values are written as boolean Excel cells.

public Boolean ConvertDateTimeColumns { get; set; } #

When true, unambiguous date or date-time columns are written as date/time Excel cells.

public Boolean ConvertPercentageColumns { get; set; } #

When true, columns containing only percentage values are written as fractional numeric Excel cells.

public CultureInfo NumericCulture { get; set; } #

Culture used when parsing detected numeric PDF table values before writing typed Excel cells.

public CultureInfo DateTimeCulture { get; set; } #

Optional culture used when parsing dates, date-times, and clock times. When null, date conversion accepts only unambiguous invariant year-first forms and clock times use invariant culture.

public Boolean MergePageContinuations { get; set; } #

When true, adjacent page-edge table segments with compatible geometry and schema are imported as one logical table.

public Boolean SuppressRepeatedBodyHeaderRows { get; set; } #

When true, identical header-like body prefixes on every merged segment are treated as additional repeated header rows and suppressed. Keep false when repeated ordinary data rows must be preserved without additional header evidence.

public Int32 MaximumContinuationSegments { get; set; } #

Maximum adjacent PDF table segments that may be combined into one logical table.

public Double ContinuationGeometryTolerancePoints { get; set; } #

Maximum per-column geometry difference, in PDF points, allowed when recognizing a page continuation.

public String EmptyWorkbookSheetName { get; set; } #

Worksheet name used when no tables are detected, keeping the produced workbook valid.