Skip to content
On this page

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 TypeDescription
.xlsxThe Excel file after the transfer process is completed.