Convert XLS to SQL

Ruby library for converting XLS to SQL

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

Convert XLS to SQL using Cells Cloud SDK for Ruby

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

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

Ruby 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-ruby/
    describe 'cells_save_as_post_document_save_as test' do
        it "should work" do
            @instance = AsposeCellsCloud::CellsApi.new($client_id,$client_secret,"v3.0","https://api.aspose.cloud/")
            name = "BOOK1.xls"
            format = 'sql'
            @instance.cells_workbook_put_convert_workbook( ::File.open(File.expand_path("data/"+name),"r")  {|io| io.read(io.size) },{:format=>format})     
        end
    end

How to convert XLS to SQL using the Cells Cloud Ruby library.

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

System Requirements

  1. ruby 2.5 or newer