Perl API to clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet
Perl Clear to clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet
Clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet - Perl REST API
API Request:
POST
https://api.aspose.cloud/v3.0/cells/clear
Clearing list objects on local Microsoft Excel and OpenOffice Calc spreadsheet is a complex task. Clearing list objects on local Microsoft Excel and OpenOffice Calc spreadsheet 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 clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet online. This Cloud SDK gives Perl developers powerful functionality and perfect API.
Perl code for clearing list objects on local spreadsheets
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 $book1Xlsx = 'Book1.xlsx'; | |
my $dataSourceXlsx = 'datasource.xlsx'; | |
my $objecttype = 'ListObject'; | |
my $mapFiles = {}; | |
$mapFiles->{$book1Xlsx}= "TestData/".$book1Xlsx ; | |
$mapFiles->{$dataSourceXlsx}= "TestData/".$dataSourceXlsx ; | |
my $request = AsposeCellsCloud::Request::PostClearObjectsRequest->new(); | |
$request->{file} = $mapFiles; | |
$request->{objecttype} = $objecttype; | |
my $result = $instance->post_clear_objects(request=> $request); |
How to use Perl API to clear list objects
- Create an account at Dashboard to get free API quota & authorization details
- Initialize CellsApi with Client Id, Client Secret, Base URL & API version
- Call post_clear_objects method to get the resultant stream
System Requirements
- Perl 5