Export WORKSHEET object to ODS format file using Cells Cloud SDK for PHP
API
POST
https://api.aspose.cloud/v3.0/cells/export
Export WORKSHEET object to ODS file from Excel file is a complex task. Export WORKSHEET to ODS format transitions is performed by our PHP SDK while maintaining the source WORKSHEET spreadsheet's main structural and logical content. Our PHP library is a professional solution to export WORKSHEET objects to ODS format files online. This Cloud SDK gives PHP developers powerful functionality and perfect ODS output.
Code example in PHP using REST API to export WORKSHEET to ODS format from spreadsheet
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php/
<?php
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LightCellsApi;
$cells = new LightCellsApi( getenv("ProductClientId"),getenv("ProductClientSecret") );
$files = array (
'DataSource' => "C:/datasource.xlsx",
'AssemblyTest' => "C:/assemblytest.xlsx"
);
$result = $cells->postExport( $files,'worksheet', 'ods' );
$filename = $result->getFiles()[0]->getFilename() ;
$fileData = $result->getFiles()[0]->getFileContent() ;
$ptr = fopen($filename, 'wb');
fwrite($ptr, base64_decode($fileData));
fclose($ptr);
How to use Cells Cloud SDK for PHP to export objects from Excel WORKSHEET to ODS
- Register an account at Dashboard to get free API quota & authorization details
- Initialize the Cells API with your Client ID, Client Secret, Base URL, and API version.
- Use the `postExport` method to retrieve the resulting stream.
System Requirements
- PHP 7.4 or newer