Search code examples
convertapi

How to select range before convert xlsx to pdf using convertapi

Using convertapi, I would like to set range and convert only selected area to pdf. Is this possible?

<?php
require_once('vendor/autoload.php');
require_once 'vendor/convertapi/convertapi- 
php/lib/ConvertApi/ConvertApi.php';
use \ConvertApi\ConvertApi;
ConvertApi::setApiSecret('secret');
$result = ConvertApi::convert('pdf', [
    'File' => 'output/spreadsheet_2.xlsx',
], 'xlsx'
);
$result->saveFiles('output');
?>

Thanks in advance.

Solution

  • Currently you can set only WorksheetName or WorksheetIndex parameters for narrowing down what you want to convert.