README

Aspose.Cells Cloud SDK for PHP empowers developers to programmatically manage Excel files with precision. This comprehensive Go library supports advanced Excel operations like cell data formatting, dynamic formulas, pivot tables, conditional styling, charts, hyperlinks, comments, and data validation. It also enables seamless Excel file conversion (XLSX, CSV, PDF, ODS), document splitting/merging, and file repair. Designed for cloud integration, this API-first solution accelerates spreadsheet automation while ensuring data integrity across platforms like AWS, Azure, and Google Cloud.

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 25.4

Full list of issues covering all changes in this release:

Summary	Category
New API for Comprehensive Formula Error Checks in Excel Workbooks	New Feature
New API for External Reference Checks in Excel Workbooks	New Feature

Support file format

Format	Description	Load	Save
XLS	Excel 95/5.0 - 2003 Workbook.	√	√
XLSX	Office Open XML SpreadsheetML Workbook or template file, with or without macros.	√	√
XLSB	Excel Binary Workbook.	√	√
XLSM	Excel Macro-Enabled Workbook.	√	√
XLT	Excel 97 - Excel 2003 Template.	√	√
XLTX	Excel Template.	√	√
XLTM	Excel Macro-Enabled Template.	√	√
XLAM	An Excel Macro-Enabled Add-In file that's used to add new functions to Excel.		√
CSV	CSV (Comma Separated Value) file.	√	√
TSV	TSV (Tab-separated values) file.	√	√
TabDelimited	Tab-delimited text file, same with TSV file.	√	√
TXT	Delimited plain text file.	√	√
HTML	HTML format.	√	√
MHTML	MHTML file.	√	√
ODS	ODS (OpenDocument Spreadsheet).	√	√
SpreadsheetML	Excel 2003 XML file.	√	√
Numbers	The document is created by Apple's "Numbers" application which forms part of Apple's iWork office suite, a set of applications which run on the Mac OS X and iOS operating systems.	√
JSON	JavaScript Object Notation	√	√
DIF	Data Interchange Format.		√
PDF	Adobe Portable Document Format.		√
XPS	XML Paper Specification Format.		√
SVG	Scalable Vector Graphics Format.		√
TIFF	Tagged Image File Format		√
PNG	Portable Network Graphics Format		√
BMP	Bitmap Image Format		√
EMF	Enhanced metafile Format		√
JPEG	JPEG is a type of image format that is saved using the method of lossy compression.		√
GIF	Graphical Interchange Format		√
MARKDOWN	Represents a markdown document.		√
SXC	An XML based format used by OpenOffice and StarOffice	√	√
FODS	This is an Open Document format stored as flat XML.	√	√
DOCX	A well-known format for Microsoft Word documents that is a combination of XML and binary files.		√
PPTX	The PPTX format is based on the Microsoft PowerPoint open XML presentation 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": "^25.3"
    }
}
```
- Run Composer install Aspose.Cells Cloud SDK:
```
composer install
```
- 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")); 
$request = new PutConvertWorkbookRequest();
$request->setFile(  ['Book1.xlsx' => 'TestData/Book1.xlsx']);
$request->setFormat("pdf");
$response = $cellsApi->putConvertWorkbook($request);
copy($response->getPathname(),"Book1.pdf");

Aspose.Cells Cloud 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