Ruled and unruled tables
Tables are found from their rules or from their aligned columns.
Convert the tables of PDF documents to Excel workbooks (XLSX) from C# and VB.NET. The tables are found from their rules or their aligned columns, and each becomes cells: numbers, percentages, currency amounts and dates as typed values with a number format, text as text.
The PDF to Excel converter is part of ExpertPdf Anywhere, the .NET library with every ExpertPdf tool. It runs in the application's process on Windows, Linux and macOS, with no native engine and no Microsoft Office.
Documentation · Online samples · NuGet · Download .zip (v22.0.0) · PDF to Excel docs · PDF to Excel online sample
How the tables of the PDF are found and read, and how the workbook is written.
The tables of the pages, with the values of their cells.
Tables are found from their rules or from their aligned columns.
Numbers, percentages, currency amounts and dates as typed values with a number format; text as text.
Culture reads the numbers as a culture writes them, for example 1.234,50 with "de-DE".
Convert a range of pages with StartPageNumber and EndPageNumber; open a protected document with UserPassword.
An XLSX workbook, to a file or as bytes.
Header rows bold and frozen, merged cells merged, with the shading, borders and column widths of the PDF.
PdfToExcelSheets.PerTable (the default) or PdfToExcelSheets.PerPage, with Sheets.
The text outside the tables on a worksheet of its own (TextOutsideTables), and the document's pictures (Images).
ConvertToExcelFile from a PDF file or stream to a file; ConvertToExcel returns the workbook as bytes.
No native engine and no platform package: only ExpertPdf.Anywhere, on Windows, Linux and macOS.
Create a PdfToExcelConverter from the ExpertPdf.Anywhere namespace, choose how the sheets are made, and convert. The tabs write a worksheet for each table, and a worksheet for each page of a German statement.
using ExpertPdf.Anywhere; var converter = new PdfToExcelConverter(); // converter.LicenseKey = "your license key"; // A worksheet for each table (the default) converter.Sheets = PdfToExcelSheets.PerTable; converter.ConvertToExcelFile("statement.pdf", "statement.xlsx");
Install with dotnet add package ExpertPdf.Anywhere. The
PDF to Word, Excel and PowerPoint topic describes every option, and the
online sample converts a sample PDF or your own to a workbook.
To create and edit workbooks, see the ExpertXLS Excel Library.
Also in ExpertPdf Anywhere: Cross-platform HTML to PDF, Word to PDF, Excel to PDF, PowerPoint to PDF, PDF to Word, PDF to PowerPoint, and every other ExpertPdf tool.
Common questions about tables, cell values, sheets and licensing.
Culture reads the numbers as a culture writes them, for example 1.234,50 in a German document with "de-DE".Sheets puts each table on a worksheet of its own (PdfToExcelSheets.PerTable, the default) or each page (PdfToExcelSheets.PerPage).TextOutsideTables writes it on a worksheet of its own, and Images keeps the document's pictures; both are on by default.PdfToExcelConverter runs in the application's process on Windows, Linux and macOS, with only the ExpertPdf.Anywhere package: no Office and no platform package.UserPassword to the user or the owner password, and StartPageNumber and EndPageNumber to the pages to convert. A document that cannot be read or converted throws PdfToExcelException.Install ExpertPdf Anywhere from NuGet and try every feature in evaluation mode. License it on the pricing page when you are ready.