Gem Gem GitHub commits since latest release (by date)

Ruby SDK for Spreadsheet Processing in the Cloud

Ruby Cloud SDK wraps Aspose.Cells REST API so you could seamlessly integrate Microsoft Excel® spreadsheet generation, manipulation, conversion & inspection features into your own applications.

Aspose.Cells Cloud SDK for Ruby offers Excel® file creation, editing, conversion, & rendering. Developers can format worksheets, rows, columns or cells to the most granular level, create & manipulate chart & pivot tables, render worksheets, charts and specific data ranges to PDF & images, add & calculate Excel's built-in and custom formulas and much more.

Cloud Spreadsheet Processor in a Nutshell

Create Excel files via API or Smart Markers.
Create & refresh Pivot Tables & Excel charts.
Split, merger, protect & un-protect spreadsheets.
Create & manipulate spark-lines & conditional formatting.
Convert charts, worksheets or data ranges to images or PDF.
Manage comments, bookmarks, OleObjects, hyperlinks & filters.
Set complex formulas & calculate results via API.
Set protection on workbook, worksheet, cell, column or row.
Create & manipulate named ranges.
Convert worksheets to PDF, XPS & SVG formats.
Convert Excel files to popular formats.

Feature & Enhancements in Version 23.12

Full list of issues covering all changes in this release:

Conversion APIs add region parameter.
Protection APIs add region parameter.
Assemble data API adds region parameter.
Merge files API adds region parameter.
Split files API adds region parameter.
Import data API adds region parameter.
Watermark API adds region parameter.
Clear object API adds region parameter.
Reverse data API adds region parameter.
Rotate data API adds region parameter.

Read & Write Spreadsheet Formats

Microsoft Excel: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML

Save Spreadsheets As

Microsoft Excel: XLS, XLSX, XLSB OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML Fixed Layout: PDF, XPS Images: PNG, JPG, TIFF, SVG Markdown: MD Other: DIF

Read Other Formats

SXC, FODS

Integrated Storage API

Since version 19.9, SDK includes support of storage operations for better user experience and unification. It gives you an ability to;

Upload, download, copy, move and delete files, including versions handling (if you are using Cloud storage that supports this feature - true by default).
Create, copy, move and delete folders.
Copy and move files and folders across separate storages in scope of a single operation.
Check if certain file, folder or storage exists.

Get Started with Aspose.Cells Cloud SDK for Ruby

First, you need to register an account at Aspose for Cloud and get the application information.

Next, execute the following command to get the latest Gem package.

gem 'aspose_cells_cloud', '~> 20.10'

or install directly

gem install aspose_cells_cloud

Delete Row from a Worksheet via Ruby Code

class Row

  include AsposeCellsCloud

  def initialize
    #Get Client Secret and Client Id from https://cloud.aspose.com
    @instance = AsposeCellsCloud::CellsApi.new($client_id,$client_secret,"v3.0")
  end

  def upload_file(file_name)
      remote_folder = 'TestData/In'
      local_name = 'Book1.xlsx'
      remote_name = 'Book1.xlsx'
      mapFiles = { }               
      mapFiles[local_name] = ::File.open(File.expand_path("TestData/"+local_name),"r")  
      uploadrequest = AsposeCellsCloud::UploadFileRequest.new( { :UploadFiles=>mapFiles,:path=>remote_folder })
      @instance.upload_file(uploadrequest)
  end

  # Delete worksheet row.
  def delete_worksheet_row
      remote_folder = 'TestData/In'
      remote_name = 'Book1.xlsx'   
      request =   AsposeCellsCloud::DeleteWorksheetRowRequest.new(:name=>remote_name,:sheetName=>'Sheet1',:rowIndex=>1,:folder=>remote_folder,:storageName=>'');
      @instance.delete_worksheet_row(request);
  end

end

row = Row.new()
puts row.delete_worksheet_row

Aspose.Cells Cloud SDKs in Popular Languages

.NET	Java	PHP	Python	Node.js	Android	Swift	Perl	GO
GitHub	GitHub	GitHub	GitHub	GitHub	GitHub	GitHub	GitHub	GitHub
NuGet	Maven	Composer	PIP	NPM	Maven	POD	CPAN	GO