Convert XLSM to SQL using Cells Cloud SDK for Perl
API
PUT
https://api.aspose.cloud/v3.0/cells/convert
Converting file formats from XLSM to SQL can be a complex task. Our Perl SDK handles all XLSM to SQL format conversions while preserving the main structural and logical content of the source XLSM spreadsheet. Our Perl library provides a professional solution for converting XLSM to SQL files online. This Cloud SDK empowers Perl developers with powerful functionality and ensures high-quality SQL output.
Perl Code Example for converting XLSM to SQL using Cells Cloud SDK
# 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 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 $format = "sql";
my $Book1Data = undef;
my $result =undef;
my @fileinfos = stat("Book1.xlsm");
my $filelength = $fileinfos[7];
open(DATA, '<', "Book1.xlsm") or die "file can not open, $!";
binmode(DATA);
read (DATA, $Book1Data, $filelength);
close (DATA);
$result = $instance->cells_workbook_put_convert_workbook(workbook => $Book1Data, format => $format);
open(my $fh, '>', "Dest.sql") or die "Could not open file!";
binmode $fh;
print $fh $result;
close $fh;
How to convert XLSM to SQL using the Cells Cloud Perl library.
- Register an account at Dashboard to get free API quota & authorization details
- Install Perl package and add the reference (import the library) to your project.
- Open the source file in Perl.
- Use the `put_convert_workbook` method to retrieve the resulting stream.
System Requirements
- Perl 5