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:

1. 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.
2. 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.

Overview

1. Get access code
   Get access code to create the credentials for the API

2. Set credentials
   Set credentials to make available the API

3. Get drives
   Returns a list of drives to which the account has access to

4. 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

5. Get worksheets
   Get worksheets from an excel file

6. Create workbook
   Create a new workbook in the default location

7. Add new worksheet
   Add a new worksheet to the workbook

8. Get cell
   Get a cell or range values

9. Write/change cell
   Write/change a cell or range value

10. Write formula
    Write a formula into a cell or range

11. (DEPRECATED) Set credentials
    Set credentials to make available the API

Changes

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

---

OS

• windows
• mac
• linux

Dependencies

License

MIT