README

ExcelOnline

Create, read, update and delete data from Excel files stored into OneDrive

Read this in other languages: English, Português, Español

How to install this module

To install the module in Rocketbot Studio, it can be done in two ways:

Manual: Download the .zip file and unzip it in the modules folder. The folder name must be the same as the module and inside it must have the following files and folders: _init_.py, package.json, docs, example and libs. If you have the application open, refresh your browser to be able to use the new module.
Automatic: When entering Rocketbot Studio on the right margin you will find the Addons section, select Install Mods, search for the desired module and press install.

Get access code
Get access code to create the credentials for the API
Set credentials
Set credentials to make available the API
Get drives
Returns a list of drives to which the account has access to
Get XLSX files
Returns a list of all the XLSX files in the root of the disk and those shared with you. If you specify a disk ID it will return the XLSX on that disk
Get worksheets
Get worksheets from an excel file
Create workbook
Create a new workbook in the default location
Add new worksheet
Add a new worksheet to the workbook
Get cell
Get a cell or range values
Write/change cell
Write/change a cell or range value
Write formula
Write a formula into a cell or range
Count rows
Returns the number of rows in an Excel workbook.
(DEPRECATED) Set credentials
Set credentials to make available the API

Mon Dec 27 11:09:45 2021 (refs/stash) On master: !!GitHub_Desktop