@flumens/fetch-onedrive-excel
TypeScript icon, indicating that this package has built-in type declarations

0.3.3 • Public • Published

Fetch OneDrive Excel file as JSON

Node.js helper function that fetches one sheet from an excel file as a JSON object.

How to use it

const fetchSheet = require('@flumens/fetch-onedrive-excel');

const file = '013SAXWCB2VHYCCDY76FF3KGKPN7T55EU2';
const sheet = 'My Sheet 1';
// const drive = '/me/drive'; // optional, see https://docs.microsoft.com/en-us/graph/api/resources/onedrive?view=graph-rest-1.0#commonly-accessed-resources

const sheet = await fetchSheet({file, sheet});

the script requires you to authenticate to your account by setting MS_TOKEN env variable. One way to get your token is by visiting https://developer.microsoft.com/en-us/graph/graph-explorer/preview and opening Access token tab where you can copy the token.

Package Sidebar

Install

npm i @flumens/fetch-onedrive-excel

Weekly Downloads

9

Version

0.3.3

License

MIT

Unpacked Size

7.21 kB

Total Files

6

Last publish

Collaborators

  • stankaitis
  • kazlauskis