AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
 [ is a cloud-native REST API that enables Perl developers to **create**, **read**, **edit**, **convert**, and **repair** spreadsheet files—including **Excel** (**XLS**, **XLS...
Built on the **Aspose.Cells Cloud Web API**, this MIT-licensed SDK supports advanced spreadsheet operations such as:
- Cell formatting, formulas, and data validation
- Pivot tables, charts, hyperlinks, and comments
- Conditional formatting and smart markers
- Worksheet merging, splitting, and protection
- Batch processing and background removal
It seamlessly integrates with **AWS**, **Microsoft Azure**, and **Google Cloud**, ensuring **high availability**, **scalability**, and **data integrity**. Ideal for serverless apps, microservices, and cloud automation workflows.
## Quick Start Guide
To begin with Aspose.Cells Cloud, here's what you need to do:
1. Sign up for an account at [Aspose for Cloud](https://dashboard.aspose.cloud/#/apps) to obtain your application details.
2. Install the Aspose.Cells Cloud Perl module from the [CPAN distribution](https://www.cpan.org/).
3. Use the conversion code provided below as a reference to add or modify your application.
## Convert an Excel File Using Perl
```perl
use strict;
use warnings;
use File::Slurp;
use MIME::Base64;
use AsposeCellsCloud::ApiClient;
use AsposeCellsCloud::CellsApi;
use AsposeCellsCloud::Configuration;
use AsposeCellsCloud::Request::ConvertSpreadsheetRequest;
my $config = AsposeCellsCloud::Configuration->new( client_id => $ENV{'CellsCloudClientId'}, client_secret => $ENV{'CellsCloudClientSecret'});
my $instance = AsposeCellsCloud::CellsApi->new(AsposeCellsCloud::ApiClient->new( $config));
my $request = AsposeCellsCloud::Request::ConvertSpreadsheetRequest->new();
$request->{spreadsheet} = 'EmployeeSalesSummary.xlsx';
$request->{format} = 'pdf';
my $response = $instance->put_convert_workbook(request=> $request);
open (my $fh, '>', 'EmployeeSalesSummary.pdf') or die "No open EmployeeSalesSummary.pdf $!";
binmode($fh);
print $fh $response;
close($fh);
```
## Support file format
| **Format** | **Description** ...
| :---------------------------------------------------------------- | :---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ...
| [XLS](https://docs.fileformat.com/spreadsheet/xls/) | Excel 95/5.0 - 2003 Workbook. ...
| [XLSX](https://docs.fileformat.com/spreadsheet/xlsx/) | Office Open XML SpreadsheetML Workbook or template file, with or without macros. ...
| [XLSB](https://docs.fileformat.com/spreadsheet/xlsb/) | Excel Binary Workbook. ...
| [XLSM](https://docs.fileformat.com/spreadsheet/xlsm/) | Excel Macro-Enabled Workbook. ...
| [XLT](https://docs.fileformat.com/spreadsheet/xlt/) | Excel 97 - Excel 2003 Template. ...
| [XLTX](https://docs.fileformat.com/spreadsheet/xltx/) | Excel Template. ...
| [XLTM](https://docs.fileformat.com/spreadsheet/xltm/) | Excel Macro-Enabled Template. ...
| [XLAM](https://docs.fileformat.com/spreadsheet/xlam/) | An Excel Macro-Enabled Add-In file that's used to add new functions to Excel. ...
| [CSV](https://docs.fileformat.com/spreadsheet/csv/) | CSV (Comma Separated Value) file. ...
| [TSV](https://docs.fileformat.com/spreadsheet/tsv/) | TSV (Tab-separated values) file. ...
| [TXT](https://docs.fileformat.com/word-processing/txt/) | Delimited plain text file. ...
| [HTML](https://docs.fileformat.com/web/html/) | HTML format. ...
| [MHTML](https://docs.fileformat.com/web/mhtml/) | MHTML file. ...
| [ODS](https://docs.fileformat.com/spreadsheet/ods/) | ODS (OpenDocument Spreadsheet). ...
| [Numbers](https://docs.fileformat.com/spreadsheet/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](https://docs.fileformat.com/web/json/) | JavaScript Object Notation ...
| [DIF](https://docs.fileformat.com/spreadsheet/dif/) | Data Interchange Format. ...
| [PDF](https://docs.fileformat.com/pdf/) | Adobe Portable Document Format. ...
| [XPS](https://docs.fileformat.com/page-description-language/xps/) | XML Paper Specification Format. ...
| [SVG](https://docs.fileformat.com/page-description-language/svg/) | Scalable Vector Graphics Format. ...
| [TIFF](https://docs.fileformat.com/image/tiff/) | Tagged Image File Format ...
| [PNG](https://docs.fileformat.com/image/png/) | Portable Network Graphics Format ...
| [BMP](https://docs.fileformat.com/image/bmp/) | Bitmap Image Format ...
| [EMF](https://docs.fileformat.com/image/emf/) | Enhanced metafile Format ...
| [JPEG](https://docs.fileformat.com/image/jpeg/) | JPEG is a type of image format that is saved using the method of lossy compression. ...
| [GIF](https://docs.fileformat.com/image/gif/) | Graphical Interchange Format ...
| [MARKDOWN](https://docs.fileformat.com/word-processing/md/) | Represents a markdown document. ...
| [SXC](https://docs.fileformat.com/spreadsheet/sxc/) | An XML based format used by OpenOffice and StarOffice ...
| [FODS](https://docs.fileformat.com/spreadsheet/fods/) | This is an Open Document format stored as flat XML. ...
| [DOCX](https://docs.fileformat.com/word-processing/docx/) | A well-known format for Microsoft Word documents that is a combination of XML and binary files. ...
| [PPTX](https://docs.fileformat.com/presentation/pptx/) | The PPTX format is based on the Microsoft PowerPoint open XML presentation file format. ...
| [OTS](https://docs.fileformat.com/spreadsheet/ots/) | OTS (OpenDocument Spreadsheet). ...
| [XML](https://docs.fileformat.com/web/xml/) | XML file. ...
| [HTM](https://docs.fileformat.com/web/htm/) | HTM file. ...
| [TIF](https://docs.fileformat.com/image/tiff/) | Tagged Image File Format ...
| [WMF](https://docs.fileformat.com/image/wmf/) | WMF Image Format ...
| [PCL](https://docs.fileformat.com/page-description-language/pcl/) | Printer Command Language Format ...
| [AZW3](https://docs.fileformat.com/ebook/azw3/) | AZ3/KF8 File Format ...
| [EPUB](https://docs.fileformat.com/ebook/epub/) | EPUB File Format ...
| [DBF](https://docs.fileformat.com/ebook/epub/) | DBF File Format ...
| [EPUB](https://docs.fileformat.com/database/dbf/) | database file ...
| [XHTML](https://docs.fileformat.com/web/xhtml/) | XHTML File Format ...
## Architecture
## [Developer Reference](docs/DeveloperGuide.md#overview)
### Manipulate Excel and other spreadsheet files in the Cloud
- **File Manipulation**: Users can upload, download, delete, and manage Excel files stored in the cloud.
- **File 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 Data**: 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 v26.3.1
Full list of issues covering all changes in this release:
| **Summary** | **Category** |
| :------------------------------------------------------------------------------------------------------------ | :----------- |
( run in 0.816 second using v1.01-cache-2.11-cpan-97f6503c9c8 )