Convert PDF to Excel

Overview

ComPDF Conversion SDK supports converting PDF documents to Microsoft Excel format (.xlsx). By extracting, parsing, and importing data from PDF into Excel, users can further edit, analyze, or share Excel files. This feature helps increase productivity, reduce manual entry errors, and simplify complex document processing tasks.

Set the content options for Excel

When converting PDF files to Excel files, you need to pay attention to the settings of the following options, which will directly affect the content written to the Excel file.

• Content options:

  If you set the excelAllContent option, the converted XLSX file will contain all the contents in the PDF.

• Worksheet options:

Option	Description
ExcelWorksheetOption::FOR_TABLE	Create one sheet for one table.
ExcelWorksheetOption::FOR_PAGE	Create one sheet for one PDF page.
ExcelWorksheetOption::FOR_DOCUMENT	Create one sheet for the entire PDF document.

Sample

This sample demonstrates how to convert from a PDF to XLSX file.

use ComPDFKit\Conversion\ExcelWorksheetOption;

$option = new ConvertOption();
Conversion::convert('Excel', 'excel.pdf', 'password', 'output.xlsx', $option);

// Set all content options.
$option->excelAllContent = true;
$option->excelWorksheetOption = ExcelWorksheetOption::FOR_DOCUMENT;
Conversion::convert('Excel', 'excel.pdf', 'password', 'output_all.xlsx', $option);