Skip to content
master
Switch branches/tags
Go to file
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
lib
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Gem Gem GitHub license 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 21.1

  • Support to convert worksheet on task API.
  • Support to add and delete cell or range in worksheet.

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)
    response =  @instance.upload_file( folder+"/"+name,  ::File.open(File.expand_path("data/"+name),"r") {|io| io.read(io.size) })
  end

  # Delete worksheet row.
  def delete_worksheet_row
    name = "myWorkbook.xlsx"
    upload_file(name)

    sheet_name = "Sheet1"
    row_index = 1
    result = @instance.cells_delete_worksheet_row(name, sheet_name, row_index,  { :folder=>folder})
  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

Product Page | Documentation | Live Demo | API Reference | Code Samples | Blog | Free Support | Free Trial