Skeet Spreadsheet Utils

This plugin is a collection of utilities for Spreadsheet. Especially works with Skeet Framework.

Installation

npm install @skeet-framework/spreadsheet-utils
Copy

with Skeet Framework

skeet yarn add -p @skeet-framework/spreadsheet-utils
Copy

Usage

The function assumes that the 'GOOGLE_APPLICATION_CREDENTIALS' environment variable is set with the path to the Google service account credentials JSON file. It returns the data from the spreadsheet.

import { addDataToSheet } from '@skeet-framework/spreadsheet-utils'

const spreadsheetId = 'spreadsheetId'
const sheetTitle = 'sheetTitle'
const run = async () => {
  const value = [
    ['Date', 'Name', 'Address', 'Amount(SOL)', 'Epoch', 'PostBalance(SOL)'],
    [1, 2, 3, 4, 5, 6],
  ]
  const data = await addDataToSheet(spreadsheetId, sheetTitle, value)
  console.log(data)
}

run()
Copy

more functions can be found in the

• Skeet Spreadsheet Utils TypeDoc

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/elsoul/skeet-spreadsheet-utils This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the Contributor Covenant code of conduct.

License

The package is available as open source under the terms of the Apache-2.0 License.

Code of Conduct

Everyone interacting in the SKEET project’s codebases, issue trackers, chat rooms and mailing lists is expected to follow the code of conduct.