@dgcode/spreadsheet-app
mocked classes for google apps script's SpreadsheetApp api
Install
$ npm install @dgcode/spreadsheet-app
Usage
import { SpreadsheetApp } from '@dgcode/spreadsheet-app';
const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
const sheet = spreadsheet.getSheets()[0];
sheet.getRange(1, 1).setValue('Hello World!');
Features
- Node.js-compatible: simulate Google Apps Script code by testing locally first
- Embeddable into Google Apps Script via gscript module
Caveats
Google frequently updates its Apps Script API so this package may fall out of sync at some point. If you really need all the brand-new features they implement, you should mock them yourself at the beginning of your script:
import { SpreadsheetApp } from '@dgcode/spreadsheet-app';
if ('function' !== typeof SpreadsheetApp.someNewMethod) {
Object.assign(SpreadsheetApp, {
someNewMethod: function() {
// ...
}
});
}
// mock ready, now run rest of app logic
// ...
import { SpreadsheetApp, Sheet } from '@dgcode/spreadsheet-app';
if ('function' === typeof Sheet && 'function' !== typeof Sheet.prototype.someNewSheetMethod) {
Object.assign(Sheet.prototype, {
someNewSheetMethod: function() {
// ...
}
});
}
// mock ready, now run rest of app logic
// ...
License
MIT