Excel Online API JavaScript

How to use the Excel Online API using JavaScript.

code How to use the Excel Online API using JavaScript

There are two ways to do this:

  1. Directly use the Excel Online API. The downside of this being it takes a significant amount of time to learn and setup all the configuration.
  2. Just use sheet2api. This takes care of all that configuration for you, all you need is the URL to your Excel Online spreadsheet to get started.

Easy setup

  1. 1 Install the JavaScript package with npm. 
    npm install sheet2api-js
  2. 2 Run Excel Online API request with JavaScript. 
    const Sheet2API = require('sheet2api-js')
const client = new Sheet2API('https://sheet2api.com/v1/FgI6zV8qT121/characters/')
client.read().then(function(data) {
    console.log(data)
})
  3. 3 Create and use your own sheet2api API.

code Examples

Here are some ready to use Excel Online API examples using the JavaScript client. Simply copy them into your project and you're good to go.

Read all rows

// Returns all rows from the first Sheet.
const Sheet2API = require('sheet2api-js')
const client = new Sheet2API('https://sheet2api.com/v1/FgI6zV8qT121/characters/')

client.read().then(function(data) {
    console.log(data)
})

Read rows which match search terms

// Returns all rows from the first Sheet, filtered by search terms.
const Sheet2API = require('sheet2api-js')
const client = new Sheet2API('https://sheet2api.com/v1/FgI6zV8qT121/characters/')

client.read({
    search: { name: 'Bugs Bunny' }
}).then(function(data) {
    console.log(data)
})

Add a new row

// Adds a new row to the Sheet.
const Sheet2API = require('sheet2api-js')
const client = new Sheet2API('https://sheet2api.com/v1/FgI6zV8qT121/characters/')

client.write({
    name: 'Bugs Bunny',
    'favourite thing': 'Carrots',
    image: 'Bugs.png'
}).then(function(data) {
    console.log(data)
})

For more in-depth examples check out the Github code repository.

check_circle It's as easy as that! 🎉

Need help? Feel free to reach out via our contact page.

Share on Twitter Share on LinkedIn Share on Facebook

Start using sheet2api now

Be up & running in seconds.

Try for FREE
check_circle No credit card required
check_circle Cancel anytime