PDF To Excel

With the PDF to Excel tool, you can convert your PDF file into an Excel file. The following examples show how to upload a test PDF file and convert it into an Excel file (.xlsx) using Java, PHP, C#, Python, and Swift languages.

Java

// Create a client
CPDFClient client = new CPDFClient(publicKey,secretKey);

// Create a task
// Create an example of a PDF tO Excel task
CPDFCreateTaskResult result = client.createTask(CPDFConversionEnum.PDF_TO_EXCEL);

// Get a task id
String taskId = result.getTaskId();

// File handling parameter settings
CPDFToExcelParameter fileParameter = new CPDFToExcelParameter();
fileParameter.setIsContainAnnot("1");
fileParameter.setIsContainImg("1");
fileParameter.setContentOptions("2");
fileParameter.setWorksheetOptions("1");

// Upload files
client.uploadFile(new File("test.pdf"), taskId, fileParameter);

// Execute task
client.executeTask(taskId);

// Query TaskInfo
CPDFTaskInfoResult taskInfo = client.getTaskInfo(taskId);

PHP

// Create a client
$client = new CPDFClient('public_key', 'secret_key');

// Create a task
// Create an example of a PDF tO Excel task
$taskInfo = $client->createTask(CPDFConversion::PDF_TO_EXCEL);

// File handling parameter settings
$file = $client->addFile('test.pdf')
    ->setIsContainAnnot('1')
    ->setIsContainImg('1')
    ->setContentOptions('2')
    ->setWorksheetOptions('1');

// Upload files
$fileInfo = $file->uploadFile($taskInfo['taskId']);

// Execute task
$client->executeTask($taskInfo['taskId']);

// Query TaskInfo
$taskInfo = $client->getTaskInfo($taskInfo['taskId']);

C#

// Create a client
CPDFClient client = new CPDFClient(publicKey,secretKey);

// Create a task
// Create an example of a PDF tO Excel task
CPDFCreateTaskResult result = client.CreateTask(CPDFConversionEnum.PDF_TO_EXCEL);

// Get a task id
string taskId = result.TaskId;

// File handling parameter settings
CPDFToExcelParameter fileParameter = new CPDFToExcelParameter();
fileParameter.IsContainAnnot = "1";
fileParameter.IsContainImg = "1";
fileParameter.ContentOptions = "2";
fileParameter.WorksheetOptions = "1";

// Upload files
client.UploadFile(new FileInfo("test.pdf"), taskId, fileParameter);

// Execute task
client.ExecuteTask(taskId);

// Query TaskInfo
CPDFTaskInfoResult taskInfo = client.GetTaskInfo(taskId);

Python

# Create a client
client = CPDFClient(public_key, secret_key)

# Create a task
# Create an example of a PDF tO Excel task
create_task_result = client.create_task(CPDFConversionEnum.PDF_TO_EXCEL)

# Get a task id
task_id = create_task_result.task_id

# File handling parameter settings
file_parameter = CPDFToExcelParameter()
file_parameter.is_contain_annot = CPDFToExcelParameter.IS_CONTAIN_ANNOT
file_parameter.is_contain_img = CPDFToExcelParameter.IS_CONTAIN_IMG
file_parameter.content_options = "2"
file_parameter.worksheet_options = "1"

# Upload files
client.upload_file('test.pdf', task_id, file_parameter)

# Execute task
client.execute_task(task_id)

# Query TaskInfo
task_info = client.get_task_info(task_id)

Swift

// Create a client
let client: CPDFClient = CPDFClient(publicKey: public_key, secretKey: secret_key)

Task { @MainActor in
    // Create a task
    // Create an example of a PDF tO Excel task
    let taskModel = await client.createTask(url: CPDFConversion.PDF_TO_EXCEL)
    
    // Get a task id
    let taskId = taskModel?.taskId ?? ""
    
    // Upload files
    let path = Bundle.main.path(forResource: "test", ofType: "pdf")
    let uploadFileModel = await client.uploadFile(filepath: path ?? "", password: "", params: [
        CPDFFileUploadParameterKey.contentOptions.string() : "2",
        CPDFFileUploadParameterKey.worksheetOptions.string() : "1",
        CPDFFileUploadParameterKey.isContainAnnot.string() : "1",
        CPDFFileUploadParameterKey.isContainImg.string() : "1"
    ], taskId: taskId)
    
    // Execute task
    let _ = await client.processFiles(taskId: taskId)
    
    // Query TaskInfo
    let taskInfoModel = await client.getTaskInfo(taskId: taskId)
}

Needed Parameters:

• contentOptions: Options to extract content (1: OnlyText, 2: OnlyTable, 3: AllContent).
• worksheetOptions: Options to create Worksheet (1: ForEachTable, 2: ForEachPage, 3: ForTheDocument).
• isContainImg: Whether to include pictures (1: yes, 0: no).
• isContainAnnot: Whether to include comments (1: yes, 0: no).

Result:

File Type	Description
.xlsx	The Excel file after the transfer process is completed.