Security News
NIST Misses 2024 Deadline to Clear NVD Backlog
NIST has failed to meet its self-imposed deadline of clearing the NVD's backlog by the end of the fiscal year. Meanwhile, CVE's awaiting analysis have increased by 33% since June.
edit-google-spreadsheet
Advanced tools
Currently, there are about 3 different node modules which allow you to read data off Google Spreadsheets, though none with a good write API. Enter `edit-google-spreadsheet`. A simple API for reading and updating Google Spreadsheets.
Currently, there are about 3 different node modules which allow you to read data off Google Spreadsheets, though none with a good write API. Enter edit-google-spreadsheet
. A simple API for reading and updating Google Spreadsheets.
Warning: There have been API changes since last release. See below.
npm install edit-google-spreadsheet
Create sheet:
var Spreadsheet = require('edit-google-spreadsheet');
Spreadsheet.create({
debug: true,
username: '...',
password: '...',
spreadsheetName: 'node-edit-spreadsheet',
worksheetName: 'Sheet1',
callback: sheetReady
});
Note: Using the options spreadsheetName
and worksheetName
will cause lookups for spreadsheetId
and worksheetId
. Use spreadsheetId
and worksheetId
for improved performance.
Update sheet:
function sheetReady(err, spreadsheet) {
if(err) throw err;
spreadsheet.add({ 3: { 5: "hello!" } });
spreadsheet.send(function(err) {
if(err) throw err;
console.log("Updated Cell at row 3, column 5 to 'hello!'");
});
}
Read sheet:
function sheetReady(err, spreadsheet) {
if(err) throw err;
spreadsheet.receive(function(err, rows) {
if(err) throw err;
console.log("Found rows:", rows);
// Found rows: { '3': { '5': 'hello!' } }
});
}
Batch edit:
spreadsheet.add([[1,2,3],
[4,5,6]]);
Batch edit starting from row 5:
spreadsheet.add({
5: [[1,2,3],
[4,5,6]]
});
Batch edit starting from row 5, column 7:
spreadsheet.add({
5: {
7: [[1,2,3],
[4,5,6]]
}
});
Named cell references:
spreadsheet.add({
3: {
4: { name: "a", val: 42 },
5: { name: "b", val: 21 },
6: "={{ a }}+{{ b }}" //forumla adding row3,col4 with row3,col5 => '=D3+E3'
}
});
Note: cell a
and b
are looked up on send()
add( obj | array )
Add cells to the batch. See examples.
send( callback( err, result ) )
Sends off the batch of add()
ed cells. Clears all cells once complete.
receive( callback( err , rows , info ) )
Recieves the entire spreadsheet. The rows
object returned is in the same object format as the cells you add()
, so add(rows)
will be valid. The info
object looks like { totalRows: 1, totalCells: 1, lastRow: 3, nextRow: 4 }
.
If true
, will display colourful console logs outputing current actions
Google account - Be careful about committing these to public repos
The spreadsheet you wish to edit. Either the Name or Id is required.
The worksheet you wish to edit. Either the Name or Id is required.
Function returning the authenticated Spreadsheet instance
info
object returned from receive()
, one could always begin add()
ing at the nextRow
, thereby appending to the spreadsheet.Thanks to googleclientlogin
for easy Google API ClientLogin Tokens
FAQs
> A simple API for reading and writing Google Spreadsheets in Node.js
The npm package edit-google-spreadsheet receives a total of 720 weekly downloads. As such, edit-google-spreadsheet popularity was classified as not popular.
We found that edit-google-spreadsheet demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
NIST has failed to meet its self-imposed deadline of clearing the NVD's backlog by the end of the fiscal year. Meanwhile, CVE's awaiting analysis have increased by 33% since June.
Security News
Cloudflare has launched a setup wizard allowing users to easily create and manage a security.txt file for vulnerability disclosure on their websites.
Security News
The Socket Research team breaks down a malicious npm package targeting the legitimate DOMPurify library. It uses obfuscated code to hide that it is exfiltrating browser and crypto wallet data.