Perl Cloud SDK to Process Excel Spreadsheets

Build Perl Apps for processing spreadsheets by creating, encrypting, splitting, watermarking, formatting & converting via Cloud SDK.

  Start Free Trial
Aspose.Cells Cloud SDK for Perl

Aspose.Cells Cloud SDK for Perl


Aspose.Cells Cloud SDK for Perl is a robust set of SDKs based on Cloud RESTful API that you can integrate with your existing or new Perl applications to support manipulation of Microsoft Excel spreadsheets, worksheets and workbooks from within your Perl Apps. No external software is required to be downloaded and installed.

Your Perl applications will be able to create, merge, encrypt, decrypt, split, apply password, convert and upload spreadsheets to the cloud. Aspose.Cells Cloud SDK for Perl allows you to work with cells, rows, charts, pivot tables, shapes, formulas, tables, ranges, OleObjects, ListObjects, conditional formatting and other features and elements.


Advanced Spreadsheet Manipulation Features



Create spreadsheets from templates, XML or smart markers


Merge multiple spreadsheets


Split spreadsheets to single worksheet spreadsheets


Convert spreadsheets to different formats


Hide & show worksheets


Manipulate rows, columns, cells & data


Protect & unprotect workbooks & worksheets


Encrypt & de-crypt spreadsheets


Export worksheets to images


Extract charts, pictures, shapes & other objects as images


Set the gradient background for charts


Office Open XML (OOXML) support


Apply styles and formatting to cells, rows, columns or ranges


Organize data by grouping rows & columns


Import/export data to & from DataTable, DataView or Array


Read, write & calculate complex formulas


Create & manipulate named ranges


Save as HTML files or streams


Autofit rows & columns


Set auto-filters & page breaks


Dynamically create & manipulate Pivot Tables


Configure page setup


Add & update text & images


Create & Manipulate comments

Support for Popular Spreadsheet Formats

Aspose.Cells Cloud SDK for Perl enables the developers to easily open and save a multitude of file formats. Some of the formats include XLS, XLSX, XLSB, XLSM, XLTX, XLTM, XML, ODS, Tab delimited, CSV, TSV and TXT. 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 Perl also offers extensive support for converting SpreadsheetML files. The SDK provides the ability to inter-convert Excel file formats without worrying about the format specific details and the conversion can be performed with fewer code lines.

Manipulate Worksheets using Perl SDK

Aspose.Cells Cloud SDK for Perl gives you complete control over spreadsheets and the data inside them. Aspose.Cells Cloud SDK for Perl allows you to manipulate rows and columns in many different ways. You can easily adjust row height & column width or auto resize the cell dimensions according to the contents in it. The SDK also offers the means to insert & delete, hide & un-hide as well as group & un-group rows and columns.

Aspose.Cells Cloud SDK for Perl also gives you complete control over how you wish to present your data in the worksheet, by offering advanced formatting features. You can apply formatting to individual row, column, cell, or you can create a range of cells and apply formatting to it. You can also add Rich Text to a single cell, apply borders, set background patterns and apply font styling. The SDK provides features to add, manipulate & calculate conditional formatting rules on the fly.

Auto fit Rows in Excel Workbooks - Perl

# Instantiate Aspose.Storage and Aspose.Cells SDK
my $storageApi = AsposeStorageCloud::StorageApi->new();
my $cellsApi = AsposeCellsCloud::CellsApi->new();
my @autoFitterOptionsBody = AsposeCellsCloud::Object::AutoFitterOptions->new('IgnoreHidden' => 'True');

# Upload file to Aspose cloud storage 
my $response = $storageApi->PutCreate(Path => 'Sample_Test_Book.xls', file => $data_path.'Sample_Test_Book.xls');
# Invoke Aspose.Cells Cloud SDK to automatically fit rows height and width    		                           
$response = $cellsApi->PostAutofitWorkbookRows(name=> $name, body=>@autoFitterOptionsBody);

if($response->{'Status'} eq 'OK'){
	# Download updated Workbook from storage server 
	my $output_file = $out_path. 'Sample_Test_Book.xls';
	$response = $storageApi->GetDownload(Path => 'Sample_Test_Book.xls');;
	write_file($output_file, { binmode => ":raw" }, $response->{'Content'});

Flexible Worksheet Display Options

Aspose.Cells Cloud SDK for Perl gives you the complete control over the worksheet's page setup thus allowing you to manipulate Excel worksheet's display options such as page breaks, page orientation, scaling, paper size, headers/footers & zoom level. You may also control the data visibility using freeze panes & print area to suit your application requirements. The SDK also enables you to work with individual cells in a spreadsheet, add comments, apply validation rules and manage hyperlinks & pictures. It also allows spreadsheet manipulation from all aspects including worksheets, rows, columns, cells, text, data, images, hyperlinks, comments, charts, pictures, OLE objects, shapes and controls to the cells. Get the ability to add or remove data in cell elements. In fact, Aspose.Cells Cloud SDK for Perl is a complete solution in cloud exposed as a REST interface. It also enables you to extract text, images, data and many other objects from the Excel spreadsheets while using simple interfaces

Furthermore, Aspose.Cells Cloud SDK for Perl allows you to manipulate spreadsheet data including text, numeric or alphanumeric with the help of simple methods. You can add, modify or remove data from cells as well as add and calculate formulas in a worksheet cell to get the resultant value.

Summarize Data with Pivot Tables

It can be difficult to get summarized information with very large spreadsheets. A Pivot Table can help you quickly summarize the flat data and to get the desired information according to your needs. Aspose.Cells Cloud SDK for Perl allows you to dynamically create Pivot Tables and Pivot Charts. You can also dynamically change the source data of a Pivot Table and refresh it. Moreover, Aspose.Cells Cloud SDK for Perl offers Smart Markers which is a great feature to populate worksheets based on some data source and to create visually effective reports. The SDK also provides an Efficient, Robust & Reliable Formula Calculation Engine that supports almost all of the standard and advanced Microsoft Excel formulas and functions. You can read, set and calculate the results of the built-in or add-in type, array and R1C1 reference style formulas.

Visualize Data with Formatting & Charts

Aspose.Cells Cloud SDK for Perl gives you complete freedom and flexibility to furnish your spreadsheets with all kinds of visual effects. It also allows you to apply different fonts with attributes, cell styles (alignment, indentation, rotation, borders, shading and coloring, protection, text wrapping and shrinking) and all types of number formats. Similarly, charts and graphics are visually appealing and can give your spreadsheet a professional look. Aspose.Cells Cloud SDK for Perl provides a comprehensive set of APIs for creating and manipulating all of the standard and custom chart types and dynamically set the data in order to refresh the charts. Apart from Chart creation, the SDK also provides the ability to update the data source for an existing chart and refresh it.

Excel to PDF, XPS, HTML & Image with High Fidelity

Aspose.Cells Cloud SDK for Perl supports rendering Excel spreadsheets, Charts, AutoShapes and OleObjects to raster image formats i.e.TIFF, JPG, PNG, GIF, BMP and SVG, as well as, to Fixed layout formats (PDF, PDF/A, XPS) or HTML format. During conversion, Aspose.Cells Cloud SDK for Perl ensures high degree of accuracy and precision. The output of SDK conforms to PDF 1.5 or PDF/A-1b specificationsand as a result, majority of conversions will be indistinguishable from the original Microsoft Excel document.

Apart from worksheet conversion, it also offers some distinctive features like conversion of charts or Shapes to images & PDF formats. More along, you also get the capabilities to Print worksheets. The conversion process is greatly flexible thus allowing you to choose a number of options for the conversion, such as re-sampling of images while converting spreadsheets to PDF or controlling the resultant image dimensions when rendering worksheets & charts to images.


Support and Learning Resources