Aspose.Cells Cloud SDK for Perl is a cloud-native REST API that enables Perl developers to create, read, edit, convert, and repair spreadsheet files—including Excel (XLS, XLSX, XLSB, XLSM), OpenDocument Spreadsheet (ODS), CSV, TSV, JSON, HTML, PDF, and more—without requiring Microsoft Excel or Office to be installed.
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:
- Sign up for an account at Aspose for Cloud to obtain your application details.
- Install the Aspose.Cells Cloud Perl module from the CPAN distribution.
- Use the conversion code provided below as a reference to add or modify your application.
Convert an Excel File Using 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 | 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. | √ | √ | | TXT | Delimited plain text file. | √ | √ | | HTML | HTML format. | √ | √ | | MHTML | MHTML file. | √ | √ | | ODS | ODS (OpenDocument 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 | 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. | | √ | | OTS | OTS (OpenDocument Spreadsheet). | √ | √ | | XML | XML file. | √ | √ | | HTM | HTM file. | √ | √ | | TIF | Tagged Image File Format | | √ | | WMF | WMF Image Format | | √ | | PCL | Printer Command Language Format | | √ | | AZW3 | AZ3/KF8 File Format | | √ | | EPUB | EPUB File Format | | √ | | DBF | DBF File Format | | √ | | EPUB | database file | | √ | | XHTML | XHTML File Format | | √ |
Architecture
Developer Reference
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 | | :------------------------------------------------------------------------------------------------------------ | :----------- | | Enhancing the DecomposeUserTask API of Aspose Cells Cloud. | Task | | Optimize the APIs related to document splitting | Improvement | | Support the accept all revisions feature for share Excel file. | New Feature |
Available SDKs
The Aspose.Cells Cloud SDK is available in multiple popular programming languages, enabling developers to integrate spreadsheet processing capabilities across various development environments.
