



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

*Read this in other languages: [English](README.md), [Português](README.pr.md), [Español](README.es.md)*

## 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 XLSX files  
Return a list with all the XLSX files in 

4. Get worksheets  
Get worksheets from an excel file

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

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

7. Get cell  
Get a cell or range values

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

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

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



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

----
### OS

- windows
- mac
- linux

### Dependencies

### License
  
![MIT](https://camo.githubusercontent.com/107590fac8cbd65071396bb4d04040f76cde5bde/687474703a2f2f696d672e736869656c64732e696f2f3a6c6963656e73652d6d69742d626c75652e7376673f7374796c653d666c61742d737175617265)  
[MIT](http://opensource.org/licenses/mit-license.ph)