README

Aspose.Cells Cloud for PHP enables you to handle various aspects of Excel files, including cell data, styles, formulas, charts, pivot tables, data validation, comments, drawing objects, images, hyperlinks, and so on. Additionally, it supports operations such as splitting, merging, repairing, and converting to other compatible file formats.

PHP package for Aspose.Cells Cloud

Enhance your PHP applications with the Aspose.Cells Cloud , enabling seamless integration with Excel, ODS, CSV, Json and other spreadsheet document formats. With its powerful APIs, developers can effortlessly read, convert, create, edit, and manipulate the contents of Excel documents without the need for any office software installed on the machine.

Manipulate Excel and other spreadsheet files in the Cloud

File Manipulation: Users can upload, download, delete, and manage Excel files stored in the cloud.
Formatting: Supports formatting of cells, fonts, colors, and alignment modes in Excel files to cater to users' specific requirements.
Data Processing: Powerful functions for data processing including reading, writing, modifying cell data, performing formula calculations, and formatting data.
Formula Calculation: Built-in formula engine handles complex formula calculations in Excel and returns accurate results.
Chart Manipulation: Users can create, edit, and delete charts from Excel files for data analysis and visualization needs.
Table Processing: Offers robust processing capabilities for various form operations such as creation, editing, formatting, and conversion, meeting diverse form processing needs.
Data Verification: Includes data verification function to set cell data type, range, uniqueness, ensuring data accuracy and integrity.
Batch Processing: Supports batch processing of multiple Excel documents, such as batch format conversion, data extraction, and style application..
Import/Export: Facilitates importing data from various sources into spreadsheets and exporting spreadsheet data to other formats.
Security Management: Offers a range of security features like data encryption, access control, and permission management to safeguard the security and integrity of spreadsheet data.

Feature & Enhancements in Version 24.12

Full list of issues covering all changes in this release:

Add the new remove duplicates api.
Add the new extract text API.
The pivot filter could not be created successfully.

Support file format

Quick Start Guide

To begin with Aspose.Cells Cloud, here's what you need to do:

Sign up for an account at Aspose for Cloud to obtain your application details.
Install the Aspose.Cells Cloud PHP Package from Packagist.

To install Aspose.Cells Cloud via Composer, follow these steps:
- Add Aspose.Cells Cloud as a dependency to your composer.json file:
```
{
    "require": {
        "aspose/cells-cloud": "^24.3"
    }
}
```
- Run Composer update to install the SDK:
```
composer update
```
- Include Composer's autoloader in your PHP code:
```
require 'vendor/autoload.php';
```
- You're now ready to use Aspose.Cells Cloud in your PHP project.
Use the conversion code provided below as a reference to add or modify your application.

Convert an Excel File Using PHP

<?php
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Request\PutConvertWorkbookRequest;

$cellsApi = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"),"v3.0",getenv("CellsCloudApiBaseUrl"));

$remoteFolder = "TestData/In";

$localName = "Book1.xlsx";
$remoteName = "Book1.xlsx";

$format = "csv";

$mapFiles = array ();
$mapFiles[$localName] = CellsApiTestBase::getfullfilename($localName);
CellsApiTestBase::ready(  $this->instance,$localName ,$remoteFolder . "/" . $remoteName ,  "");

$request = new PutConvertWorkbookRequest();
$request->setFile( $mapFiles);
$request->setFormat( $format);
$$cellsApi->putConvertWorkbook($request);
?>

Aspose.Cells Cloud in Popular Languages

aspose / cells-sdk-php

Maintainers

Details