aspose/cells-sdk-php

A PHP library for communicating with the Aspose.Cells Cloud API

23.5 2023-05-25 12:25 UTC

README

Packagist Version Packagist PHP Version Support Packagist Downloads GitHub license GitHub commits since latest release (by date)

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