Link Search Menu Expand Document

PDF to XLS - extract all pages into a single worksheet

By default, each PDF pages will be extracted into their individual worksheets in the excel output. To change this, you need to disable the PageToWorksheet by setting it to false.

Here’s how to use it in the profiles param:

{
   "profiles": "{ 'PageToWorksheet': false }"
}

Zapier

On Zapier, kindly go to your PDF.co account and copy-paste the code below in the Custom Profiles field.

{ 'PageToWorksheet': false }

Integromat/Make

On Integromat/Make, kindly go to your PDF.co account and copy-paste the code below in the Custom Profiles field.

{ 'PageToWorksheet': false }

C#

If you are using C#, here’s how you can add the profiles param:

//extract all pages into a single worksheet
var Profiles = @"{ ""profiles"": [ { ""profile1"": { ""PageToWorksheet"": false } } ] }";

//add in requests params
parameters.Add("profiles", Profiles); 

JavaScript

If you are using JavaScript, here’s how you can add the profiles param:

//extract all pages into a single worksheet
var Profiles = @"{ ""profiles"": [ { ""profile1"": { ""PageToWorksheet"": false } } ] }";

//add in JSON payload for api request
profiles: Profiles

PHP

If you are using PHP, here’s how you can add the profiles param in your PHP code:

// Set custom profiles parameter
$Profiles = "{ \"profiles\": [ { \"profile1\": { \"PageToWorksheet\": false } } ] }";

// Prepare requests params
$parameters["profiles"] = $Profiles;

Python

If you are using Python, here’s how you can add the profiles param in your Python code:

// Set custom profiles parameter
profiles = '{ "profiles": [ { "profile1": { "PageToWorksheet": false} } ] }'


// Prepare requests params
parameters["profiles"] = profiles