2.0.0 • Published 4 years ago
@methodus/google-spreadsheet v2.0.0
V4 Google Spreadsheet Access (node.js)
This is a CRUD based operations package for Google sheets.
API
import { Sheet, getSheet, SheetDataResult } from '@methodus/google-spreadsheet';
const sheet:Sheet = getSheet(sheetId, {client_email: 'test@gmail.com', private_key: 'XXXXXXXXXXXX'});
Get filtered rows
function filter(row: SpreadsheetRow<Model>){
return row.data.email === email
}
const result = sheet.query<Model>('Sheet1', filter, start, end, sorts);
Insert
const data = new Model();
const result = sheet.insert<Model>('Sheet1',data);
const result = sheet.insertMany<Model>('Sheet1',[data]);
Update
const data = new Model();
data.keyid = keyvalue;
const result = sheet.update<Model>('Sheet1',data);
function filter(row: SpreadsheetRow<Model>){
return row.data.email === email
}
const result = sheet.updateBy<Model>('Sheet1',filter, data);
Delete
const data = new Model();
data.keyid = keyvalue;
const result = sheet.delete<Model>('Sheet1',data);
const result = sheet.deleteMany<Model>('Sheet1',[keyvalue,keyvalue,keyvalue]);
2.0.0
4 years ago
1.0.26
4 years ago
1.0.25
4 years ago
1.0.24
4 years ago
1.0.23
4 years ago
1.0.21
4 years ago
1.0.19
4 years ago
1.0.18
4 years ago
1.0.17
4 years ago
1.0.16
4 years ago
1.0.15
4 years ago
1.0.14
4 years ago
1.0.12
4 years ago
1.0.11
4 years ago
1.0.10
4 years ago
1.0.9
4 years ago
1.0.8
4 years ago
1.0.6
4 years ago
1.0.5
4 years ago
1.0.2
4 years ago
1.0.4
4 years ago
1.0.3
4 years ago
1.0.1
4 years ago
1.0.0
4 years ago
0.0.7
4 years ago
0.0.6
4 years ago
0.0.5
4 years ago
0.0.4
4 years ago
0.0.3
4 years ago
0.0.2
4 years ago
0.0.1
4 years ago