aspose / cells-sdk-php
A PHP library for communicating with the Aspose.Cells Cloud API
Requires
- php: >=5.5
- ext-curl: *
- ext-json: *
- ext-mbstring: *
- guzzlehttp/guzzle: ^7.4
Requires (Dev)
- phpunit/phpunit: ^4.8
- squizlabs/php_codesniffer: ~2.6
This package is not auto-updated.
Last update: 2023-05-25 12:36:18 UTC
README
PHP SDK for Spreadsheet Processing in Cloud
This Cloud SDK enhances your PHP-based Cloud apps to process & manipulate Microsoft Excel spreadsheets without requiring Microsoft Office.
Cloud Spreadsheet Processor in a Nutshell
- Create new spreadsheets using Excel files as templates or Smart Marker.
- Load & process Excel spreadsheets & worksheets via Cloud SDK.
- Merge or split workbooks.
- Protect or unprotect worksheets.
- Import data to worksheets.
- Calculate formulas or add/update formulas to worksheet cells.
- Add, update or delete charts, worksheets, images, shapes, hyperlinks & validations.
- Add or remove cells area, conditional formatting or OleObjects from Excel worksheets.
- Insert or delete horizontal or vertical page breaks
- Add ListObject at a specific place within an Excel file & convert to a range of cells.
- Delete specific or all ListObjects in a worksheet or summarize data with Pivot Table.
- Apply custom criteria to list filters of various types.
- Get, update, show or hide chart legend & titles.
- Manipulate page setup, header & footer.
- Create, update, fetch or delete document properties.
- Fetch the required shape from worksheet.
- Leverage the power of Pivot Tables & Ranges.
Feature & Enhancements in Version 23.5
- Fix few method names for spelling error.
Read Other Formats
SXC, FODS
Integrated Storage API
Since version 19.9, SDK includes support of storage operations for better user experience and unification. It gives you an ability to;
- Upload, download, copy, move and delete files, including versions handling (if you are using Cloud storage that supports this feature - true by default).
- Create, copy, move and delete folders.
- Copy and move files and folders across separate storages in scope of a single operation.
- Check if certain file, folder or storage exists.
Get Started with Aspose.Cells Cloud SDK for PHP
First, create an account at Aspose for Cloud and get your application information.
Get the SDK
The complete source code is available at the GitHub Repository. You can either directly use it in your project via source code or get it from Packagist distribution (recommended).
Install via Composer
Aspose.Cells Cloud SDK for PHP is available on Packagist as the cells-sdk-php
package. Run the following command to get the package.
composer require aspose/cells-sdk-php
Use Composer's autoload command to start using the SDK.
require_once('vendor/autoload.php');
Import Data to Excel Worksheet via PHP
<?php require_once('vendor\autoload.php'); use \Aspose\Cells\Cloud\Api\CellsApi; use \Aspose\Cells\Cloud\Model\ImportIntArrayOption; class Workbook { public $cells; public function __construct() { $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl")); } public function postImportDataCloudFile() { $name ='Book1.xlsx'; $folder = "Temp"; $data = new ImportIntArrayOption(); $data->setDestinationWorksheet('Sheet1'); $data->setFirstColumn(1); $data->setFirstRow(3); $data->setImportDataType('IntArray'); $data->setIsVertical('true'); $data->setData(array(1, 2, 3, 4)) ; $sourceFolder = ".\\data\\"; $this->cells->uploadFile($folder . "/" . $name , $sourceFolder. $name); $result = $this->cells->cellsWorkbookPostImportData($name, $data, $folder); } } $workbook = new Workbook(); $workbook->postImportDataCloudFile(); ?>
Aspose.Cells Cloud SDKs in Popular Languages
.NET | Java | Python | Ruby | Node.js | Android | Swift | Perl | GO |
---|---|---|---|---|---|---|---|---|
GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub |
NuGet | Maven | PIP | GEM | NPM | Maven | POD | CPAN | GO |
Product Page | Documentation | Live Demo | API Reference | Code Samples | Blog | Free Support | Free Trial