Convert XLS to SQL

Perl library for converting XLS to SQL

Use the Conversion API of of Cells Cloud to create customized spreadsheet workflows in Perl projects. This is a professional solution to convert XLS to SQL and other document formats online using Perl.

C#
Java
Python
PHP
Go
Node
Perl
Swift
Ruby
Android

Convert XLS to SQL using Cells Cloud SDK for Perl

API
PUT
https://api.aspose.cloud/v3.0/cells/convert
Try it

Converting file formats from XLS to SQL can be a complex task. Our Perl SDK handles all XLS to SQL format conversions while preserving the main structural and logical content of the source XLS spreadsheet. Our Perl library provides a professional solution for converting XLS to SQL files online. This Cloud SDK empowers Perl developers with powerful functionality and ensures high-quality SQL output.

Perl Code Example for converting XLS 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.xls");
    my $filelength = $fileinfos[7];
    open(DATA, '<', "Book1.xls") 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 XLS to SQL using the Cells Cloud Perl library.

  1. Register an account at Dashboard to get free API quota & authorization details
  2. Install Perl package and add the reference (import the library) to your project.
  3. Open the source file in Perl.
  4. Use the `put_convert_workbook` method to retrieve the resulting stream.

System Requirements

  1. Perl 5