Perl API to merge multiple Excel files into a file.

Perl library to merge multi Excel files into a file.

Use Cells Merge REST API to merge multiple Excel files into a file in Perl. This professional solution merge multiple Excel files into a Microsoft Excel or OpenOffice Calc spreadsheet using Perl.

C#
Java
Python
PHP
Go
Node
Perl
Swift
Ruby
Android

Merge multiple Excel files into a file - Perl REST API

API Request:
POST
https://api.aspose.cloud/v3.0/cells/merge
Api Reference

Merging multiple Excel files into a file is a complex task. Merging multiple Excel files into a file transitions is performed by our Perl SDK while maintaining the source spreadsheet's main structural and logical content. Our Perl library is a professional solution to merge multiple Excel files into a file online. This Cloud SDK gives Perl developers powerful functionality and perfect API.

Code example in Perl using REST API to merging multiple Excel files into a file

# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-perl/
use strict;
use warnings;
use utf8;
use File::Slurp;
use MIME::Base64;
use AsposeCellsCloud::CellsApi;
my $config = AsposeCellsCloud::Configuration->new( client_id => $ENV{'ProductClientId'}, client_secret => $ENV{'ProductClientSecret'});
my $instance = AsposeCellsCloud::CellsApi->new(AsposeCellsCloud::ApiClient->new( $config));
my $assemblyTestXlsx = 'assemblytest.xlsx';
my $dataSourceXlsx = 'datasource.xlsx';
my $format = 'csv';
my $mergeToOneSheet = 'true';
my $mapFiles = {};
$mapFiles->{$assemblyTestXlsx}= "TestData/".$assemblyTestXlsx ;
$mapFiles->{$dataSourceXlsx}= "TestData/".$dataSourceXlsx ;
my $request = AsposeCellsCloud::Request::PostMergeRequest->new();
$request->{file} = $mapFiles;
$request->{format} = $format;
$request->{merge_to_one_sheet} = $mergeToOneSheet;
my $result = $instance->post_merge(request=> $request);
view raw Example-PostMerge.pl hosted with ❤ by GitHub


How to use Perl API to merge

  1. Create an account at Dashboard to get free API quota & authorization details
  2. Initialize CellsApi with Client Id, Client Secret, Base URL & API version
  3. Call post_merge method to get the resultant stream


System Requirements

  1. Perl 5