
Security News
vlt Launches "reproduce": A New Tool Challenging the Limits of Package Provenance
vlt's new "reproduce" tool verifies npm packages against their source code, outperforming traditional provenance adoption in the JavaScript ecosystem.
google-spreadsheet-reader
Advanced tools
Converts a Google SpreadSheet to a pretty JSON.
This works with both server server-side and client-side :)
$ npm install google-spreadsheet-reader
Select [File > Publish to the web…]
Click [Publish]
Done!
After toggle [Published content & settings], select documents you want to publish. Then click [Start publishing]
After toggle [Published content & settings], click [Stop publishing]
For example, see this spreadsheet example.
Use the key
from the URL.
var SpreadSheet = require('google-spreadsheet-reader');
// Create SpreadSheet Object
var spreadSheet = new SpreadSheet('1lBbCRh6N2Ozz8oEB9fIRN4vuUNQhErqGbAQbHAu2w5Q');
spreadSheet.load()
.then(function(res) { console.log(res); }) // beautiful JSON!
.catch(function(err) { console.error(err.message); }); // Aw, something happened.
Result:
You can change the property names to camelCase by setting the camelcase
flag to true
.
spreadSheet.load({ camelcase: true })
.then(function(res) { console.log(res); }) // JSON with camelcased properties!
.catch(function(err) { console.error(err.message); });
Result:
You can represent JSON data types with the following spreadsheet configurations.
Add type next to property. (e.g. Population: int
)
For Array
, split items with |
(e.g. Genotype: Array
)
Object
You can create an Object
type and with the first column, define its properties.
Add : Object
next to the first property. (e.g. id: Object
)
FAQs
Converts a Google SpreadSheet to a pretty JSON.
The npm package google-spreadsheet-reader receives a total of 15 weekly downloads. As such, google-spreadsheet-reader popularity was classified as not popular.
We found that google-spreadsheet-reader 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
vlt's new "reproduce" tool verifies npm packages against their source code, outperforming traditional provenance adoption in the JavaScript ecosystem.
Research
Security News
Socket researchers uncovered a malicious PyPI package exploiting Deezer’s API to enable coordinated music piracy through API abuse and C2 server control.
Research
The Socket Research Team discovered a malicious npm package, '@ton-wallet/create', stealing cryptocurrency wallet keys from developers and users in the TON ecosystem.