Work with Excel Spreadsheets in Cloud

Create, Manipulate, Convert or Protect Excel spreadsheets (10+ file formats) using Aspose.Cells Cloud SDK for PHP.

  Start Free Trial
Aspose.Cells Cloud SDK for PHP

Aspose.Cells Cloud SDK for PHP

 
 

Support for Famous File Formats

Aspose.Cells Cloud SDK for PHP is developed on top of Cloud REST API that gives the complete freedom of platform, allowing a higher level of abstraction so that you don't need to know the REST API to use this SDK.

Aspose.Cells Cloud SDK for PHP helps you to create, manipulate and convert spreadsheets in the cloud. Developers can inter-convert popular Excel spreadsheet formats as well as render the supported spreadsheet formats to raster & fixed-layout formats. The Aspose.Cells Cloud SDK for PHP provides a support for developers to easily open and save various popular file formats. These include XLS, XLSX, XLSM, XLTX, XLTM, ODS, Tab delim., CSV, TXT, PDF, SpreadsheetML, HTML, TIFF, JPG, PNG, BMP and SVG. The Office Open XML (OOXML) is a container format for several specialized XML-based markup languages. OOXML SpreadsheetML documents mostly come as XLSX files, which are ZIP packages. In addition to XLSX format, Aspose.Cells Cloud SDK for PHP also provides extensive support for converting SpreadsheetML documents.

 

Advanced Excel Spreadsheet manipulation Features

 

 

Create spreadsheets from templates, XML or smart markers

 

Split spreadsheets to single worksheet spreadsheets

 

Convert spreadsheets to different formats

 

Merge multiple spreadsheets

 

Manipulate rows, columns, cells & data

 

Encrypt & de-crypt spreadsheets

 

Protect & unprotect workbooks & worksheets

 

Export worksheets to images

 

Extract charts, pictures, shapes & other objects as images

 

Set complex formulae

 

Auto fit rows

 

Add & update text & images

 

Manipulate comments

 

Hide & show worksheets

 

PHP SDK for 5.6 or higher

Jump start Excel Spreadsheet Processing with REST API

In order to get started with Aspose.Cells Cloud SDK for PHP, you don't need to download or install anything. All you need to do is create an account at Aspose for Cloud and get your application information. Once you have the App SID & key, you are ready to use Aspose.Cells Cloud SDK for PHP on any platform. Aspose.Cells Cloud SDK for PHP provides you all the features to create, edit, and convert spreadsheets. It also allows you to extract data from the spreadsheets for further processing or storage.

Get the ability to add or remove data in cell elements. The data may include comments, pictures, hyperlinks and any validation rules applied over cells. Nevertheless, Aspose.Cells Cloud SDK for PHP is a complete solution in the cloud exposed as a REST interface.

Manage Worksheets

This SDK gives you complete control over spreadsheets and the data in them. The Excel cloud API helps you create formulas and make sophisticated calculations based on user input or external data sources. You may use it to work with individual cells in a spreadsheet, add comments, apply validation rules and manage hyperlinks & pictures. The API also allows to manipulate all aspects of the spreadsheets including Worksheets, Rows, Columns, Cells, Text, Data, Images, Links, Comments, Charts and many more. Aspose.Cells Cloud SDK for PHP puts these features at your fingertips, through a cloud-based API.

Convert Spreadsheets to PDF format

Aspose.Cells Cloud SDK for PHP goes an extra mile while performing the conversion of Microsoft Excel documents to PDF format with a high degree of precision. As a result, majority of conversions will be indistinguishable from the original Microsoft Excel document..

Convert Excel workbook to PDF - PHP


// Upload file to Aspose Cloud Storage
Utils::uploadFile("input.xltx");
$body = '{"SaveFormat": "PDF"}';
$result = $this->cells->PostDocumentSaveAs("input.xltx", $newfilename = "resultant.pdf", $isAutoFitRows = null, $isAutoFitColumns = null, $storage = null, $folder = null, $body);
print_r($result);

Render Spreadsheet as Images

Aspose.Cells Cloud SDK for PHP supports rendering Excel spreadsheets, Charts, AutoShapes and OleObjects to most commonly used image formats like JPG, BMP, GIF, PNG. During conversion, the SDK ensures accuracy and precision to generate output with great fidelity.

Convert Excel worksheets to Image format - PHP


AsposeApp::$appSID = Utils::appSID;
AsposeApp::$apiKey = Utils::apiKey;
$this->cells = new CellsApi();
$result = $this->cells->GetWorkSheetWithFormat($name="myWorkbook.xlsx", $sheetName="Sheet1", $format="gif", $verticalResolution = null, $horizontalResolution = null, $storage = null, $folder = null);
$fh = fopen(realpath(__DIR__ . '/../../..') . '/Data/Output/Sheet1.png', 'w');
fwrite($fh, $result);
fclose($fh);

Extract Contents from Excel Spreadsheet

Aspose.Cells Cloud SDK for PHP enables you to extract text, images, data and many other objects from the Excel spreadsheets while using simple interfaces exposed by the REST API. Apart from extraction, it also allows you to manipulate spreadsheet data including text, numeric or alphanumeric with the help of simple API methods. You can add, modify or remove data from cells as well as add and calculating formulas in a worksheet cell to get the resultant value.

 

Support and Learning Resources

 
  

Aspose.Cells also offers individual Workbook processing SDKs for other popular languages as listed below: