Aspose.Cells  Cloud SDK for Ruby

Ruby REST SDK for Excel Spreadsheets

Create, read, write, merge, split, encrypt, and convert Microsoft Excel & OpenOffice spreadsheets in the cloud.

Get Started

Overview

The Aspose.Cells Cloud SDK for Ruby facilitates the rapid development of robust cloud-based applications for Microsoft Excel, iWork office numbers, OpenOffice spreadsheets and other format files. It provides functionalities for generating, reading, merging, splitting, encrypting, and converting files in the Ruby programming language. This SDK is built upon the Aspose.Cells Cloud API and operates under the MIT license.
The Aspose.Cells Cloud SDK for Ruby empowers your Ruby applications to access and modify various elements within cloud worksheets. It enables manipulation of auto-filters, workbooks, cells, columns, rows, charts, shapes, hyperlinks, conditional formatting, OleObjects, page breaks, ListObjects, pivot tables, tasks, and ranges. This SDK enables your Ruby program to convert a variety of formats such as XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, ODS to DIF, PDF, XPS, TIFF, SVG, Markdown, XML, SpreadsheetML, CSV, TSV, TXT, HTML, and MHTML.
create.png

Beginning Excel Spreadsheet Processing with the Ruby SDK.

To begin, start by installing the Aspose.Cells Cloud library for Ruby and then create an account on Aspose for Cloud to obtain your application credentials. Once you have the application SID and key, you can leverage them within any of the supported Ruby platforms utilizing the Aspose.Cells Cloud SDK for Ruby. This SDK offers a comprehensive array of features for creating, editing, and converting spreadsheets. Moreover, it enables you to extract data from spreadsheets for subsequent processing or storage.
computer.png

The Aspose.Cells Cloud SDK for Ruby facilitates numerous operations such as creating, splitting, merging, search and replace of text, applying password protection, exporting to supported file formats, reading workbook text items, auto-fitting workbook rows while ignoring hidden elements, encrypting workbook passwords with varied encryption key lengths, importing data to workbooks, calculating all formulas, setting formula calculation precision strategy, utilizing smart markers, converting workbooks between formats, and applying passwords to allow content modification.

you can perform a variety of operations such as deleting specific rows or all rows within a worksheet, accessing worksheet cell data or cell style via cell names, retrieving row or column data based on their indices, calculating cell formulas, clearing cell contents, copying cell data to another cell, duplicating worksheet columns and rows, grouping worksheet rows and columns, hiding specific worksheet rows and columns, defining styles for worksheet columns and rows, setting html string values within cells, assigning values to a range of cells, and modifying various worksheet settings.

operatest.png

Supported File Formats

Input Format

  • Microsoft Excel: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM
  • Open Office:ODS
  • Extensible Markup Language: XML, Josn
  • Text: CSV, TSV, TXT, Markdown
  • Web: HTML, MHTML

Output Format

  • Microsoft Excel: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, XLAM
  • Open Office: ODS
  • iWork Office: Number
  • Microsoft Office: Docx, Pptx
  • Extensible Markup Language: XML, Josn
  • Text: CSV, TSV, TXT, Markdown
  • Web: HTML, MHTML
  • Image: SVG, TIFF, PNG, BMP, EMF, JPEG, GIF
  • Adobe Portable Document: Pdf
  • Data Interchange Format: Dif
  • XML Paper Specification Format: XPS
  • Database Script: SQL
 
 

Advanced Spreadsheet Manipulation Features

 
 
Add filters with custom criteria for lists
Support for multiple types of list filters
Get information regarding Chart Area border or fill format
Add, update, and delete charts in worksheet
Get, update, show or hide chart legend
Get, update, chart title and set its visibility
Add or remove a cell area for conditional formatting
Add, update, and delete worksheet hyperlinks
Add a ListObject at specified place in the Excel file
Delete specific or all ListObjects in a worksheet
Convert ListObject or table to a range of cells
Summarize data of large ListObject or Table with Pivot Table
Add OleObjects to Excel worksheet
Delete specific or all OleObjects from worksheet
Insert or delete, horizontal or vertical page breaks
Manipulate page setup, header footer
Add, update, fetch or delete worksheet pictures
Create, update, fetch or delete document properties
Fetch the required shape from worksheet
Add, update or delete shapes from a worksheet
Add, update or delete validations for worksheets
 
 
 

Platform Independence