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.11

Full list of issues covering all changes in this release:

Optimize import xml data into Excel file.
Optimize import json data into Excel file.
Remove deprecated functions, class and test case.

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() {
        $remoteFolder = "TestData/In";
        $remoteName = "Book1.xlsx";

        $importOptionData = array ( 1, 2,3, 4        );
        $importOption = new \Aspose\Cells\Cloud\Model\ImportIntArrayOption();
        $importOption->setDestinationWorksheet("Sheet1" ); 
        $importOption->setFirstColumn(1 ); 
        $importOption->setFirstRow(3 ); 
        $importOption->setImportDataType("IntArray" ); 
        $importOption->setIsInsert('true' ); 
        $importOption->setIsVertical('true' ); 
        $importOption->setData($importOptionData ); 
     
        $request = new PostImportDataRequest();
        $request->setName( $remoteName);
        $request->setImportOption( $importOption);
        $request->setFolder( $remoteFolder);
        $request->setStorageName( "");
        $this->instance->postImportData($request);
}
}

$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

aspose / cells-sdk-php

Maintainers

Details

Add Maintainer

Remove Maintainer