Aspose.Cells Cloud SDK for Perl – Solution for Integrating Microsoft Excel and OpenOffice Spreadsheet in Perl Using Powerful Aspose.Cells Cloud APIs

Share on FacebookTweet about this on TwitterShare on LinkedIn

Aspose.Cells Cloud

Aspose.Cells Cloud’s platform independent document manipulation API is a true REST API that can be used with any language: .NET, Java, Perl, PHP, Ruby, Rails, Python, Node.js and many more. You can use it with any platform — web, desktop, mobile, and cloud.

With Aspose.Cells Cloud you can work with all aspects of spreadsheets: worksheets, rows, columns, cells, text, data, images, links, comments, formulas, charts, and many more, PDF, XPS, EPUB and many other formats. Aspose.Cells Cloud is a complete solution for performing any operation you can wish to perform on Microsoft Excel and OpenOffice spreadsheets in the cloud. Learn More

What’s new in the latest release

This is a major release for Aspose.Cells Cloud SDK for Perl. It covers all the Aspose.Cells Cloud APIs. This SDK provides a complete solution for integrating Microsoft Excel in Perl using powerful Aspose.Cells Cloud APIs, so you can perform any operation on Microsoft Excel and OpenOffice spreadsheets in the cloud seamlessly.

Source Code Repository

Complete source code of this release of Aspose.Cells Cloud SDK for Perl is freely available on your favorite GitHub and Codeplex repositories.

 

Setup

Aspose.Cells Cloud SDK for Perl is also available as released package in the CPAN (Perl Archive Network). You can bypass GitHub source code repository and depend directly on the released package by installing from npm:

Aspose.Cells Cloud SDK for Perl – CPAN installation


sudo cpan AsposeCellsCloud::CellsApi

You can also manually build the module by downloading the code and executing the following in the root directory of the download:


perl Build.PL
./Build
./Build test
./Build install

Data

In order to manipulate any files, you first need to upload them to the Aspose cloud storage or 3rd party cloud storage using Aspose.Storage Cloud SDK for Perl.

Quick SDK Tutorial


use lib 'lib';
use strict;
use warnings;
use File::Slurp; # From CPAN

use AsposeStorageCloud::StorageApi;
use AsposeStorageCloud::ApiClient;
use AsposeStorageCloud::Configuration;

use AsposeCellsCloud::CellsApi;
use AsposeCellsCloud::ApiClient;
use AsposeCellsCloud::Configuration;

use AsposeCellsCloud::Object::SaveOptions;

$AsposeCellsCloud::Configuration::app_sid = 'XXX';
$AsposeCellsCloud::Configuration::api_key = 'XXX';

$AsposeCellsCloud::Configuration::debug = 1;

$AsposeStorageCloud::Configuration::app_sid = $AsposeCellsCloud::Configuration::app_sid;
$AsposeStorageCloud::Configuration::api_key = $AsposeCellsCloud::Configuration::api_key;

#Instantiate Aspose.Storage API SDK 
my $storageApi = AsposeStorageCloud::StorageApi->new();

#Instantiate Aspose.Cells API SDK
my $cellsApi = AsposeCellsCloud::CellsApi->new();

my $data_path = '../data/';

#set input file name
my $name = 'Sample_Test_Book.xls';
my $newfilename = 'Sample_Test_Book.pdf';
my $format = 'pdf';
my @saveOptionsBody = AsposeCellsCloud::Object::SaveOptions->new('desiredPPI' => 300, 'jpegQuality'=>70, 'OnePagePerSheet'=>'True', 'SaveFormat'=>'pdf');

#upload file to aspose cloud storage 
my $response = $storageApi->PutCreate(Path => $name, file => $data_path.$name);

#invoke Aspose.Cells Cloud SDK API to convert workbook to different file formats using cloud storage            		                           
$response = $cellsApi->PostDocumentSaveAs(name=> $name, newfilename=>$newfilename, format=>$format, body=>@saveOptionsBody);

if($response->{'Status'} eq 'OK'){
	my $destfilename = $response->{'SaveResult'}->{'DestDocument'}->{'Href'};
	print("n FileName: " . $destfilename);
	#download updated Workbook from storage server 
	my $output_file = 'C:/temp/'. $destfilename;
	$response = $storageApi->GetDownload(Path => $destfilename);
	write_file($output_file, { binmode => ":raw" }, $response->{'Content'});
}

Aspose.Cells Cloud API Documentation

Aspose.Cells Cloud Documentation is available to guide developers to get familiar with the specific resources and operations within the Aspose.Cells Cloud REST API.

Aspose.Cells Cloud SDK for Perl Examples

Aspose.Cells Cloud SDK for Perl Examples are also available to guide developers to get familiar with SDK and its usage to invoke resources and operations using the Aspose.Cells Cloud REST API. Please see the SDK examples of following categories.

Start a Free Trial Today

Start a free trial today – all you need is to sign up with the Aspose Cloud service. Once you have signed up, you are ready to try the powerful file processing features offered by Aspose Cloud.