PdfToExcelConverter Class |
The PDF to Excel converter class. Converts the tables of a PDF document to an Excel workbook (xlsx).
Inheritance HierarchySystemObject
ExpertPdf.AnywherePdfToExcelConverter
Namespace: ExpertPdf.AnywhereAssembly: ExpertPdf.Anywhere (in ExpertPdf.Anywhere.dll) Version: 22.0
Syntaxpublic class PdfToExcelConverter
Public Class PdfToExcelConverter
The PdfToExcelConverter type exposes the following members.
Constructors
Properties| | Name | Description |
|---|
 | Culture |
The culture numbers, percentages, currency amounts and dates are read in, by name ("en-US", "de-DE"). The
default value is null, which takes the PDF's language, else the formats the values themselves show.
|
 | EndPageNumber |
The page number where the conversion will end. The default value is 0 which means that all the pages starting
from StartPageNumber are converted.
|
 | Images |
The PDF's images and its vector art (icons, charts, logos) as pictures, on rows of their own in reading order:
on a page's worksheet, or on the worksheet after the tables'. They never lie over a cell, so one drawn in a
table comes above it, and what lies behind text is left out. The default value is true.
|
 | LicenseKey |
The license key string received after the product purchase or a demo license key. When this property is null
the converter runs in demo mode and marks the workbook it writes.
|
 | Sheets |
A worksheet per table (the default) or a worksheet per page.
|
 | StartPageNumber |
The page number from where the conversion will start. The default value is 1.
|
 | TextOutsideTables |
With PerTable: the text outside the tables on a worksheet of its own, after
the tables' worksheets. The default value is true; false leaves only the tables.
|
 | UserPassword |
The password to open the PDF document with: the user password or the owner password. The default value is
null.
|
Top
Methods
Remarks
The pages are read as text in reading order and their tables are found from their rules or their aligned columns.
Each table becomes cells: numbers, percentages, currency amounts and dates as typed values with a number format,
text as text, header rows bold and frozen, merged cells merged, the shading and borders the PDF draws, and the
column widths of the PDF. The conversion runs in the application's process; no native engine is needed.
ExamplePdfToExcelConverter converter = new PdfToExcelConverter();
converter.LicenseKey = "...";
converter.ConvertToExcelFile("statement.pdf", "statement.xlsx");Dim converter As New PdfToExcelConverter()
converter.LicenseKey = "..."
converter.ConvertToExcelFile("statement.pdf", "statement.xlsx")
See Also