Releases: bpk68/g-sheets-api
Dependency updates and Sheet number fix
What's Changed
- Fixes Sheet number loading mechanism
- Update dependency @babel/core to v7.18.13 by @renovate in #127
- Update babel monorepo by @renovate in #128
- Bump decode-uri-component from 0.2.0 to 0.2.2 by @dependabot in #132
- Bump json5 from 1.0.1 to 1.0.2 by @dependabot in #133
- Update dependency cross-fetch to v3.1.6 by @renovate in #134
- Update dependency nodemon to v2.0.22 by @renovate in #129
- Bump minimatch from 3.0.4 to 3.1.2 in /nodedemo by @dependabot in #135
This release features a large improvement and change to how the sheetNumber option works when supplied as part of the options object during the initial call.
Previously, the sheetNumber option (typically supplied as a number, obvs. 🤷♀️) was appended to the fixed string 'Sheet' which is how Google names new sheets -- you add a new Sheet, it gets called 'Sheet3', 'Sheet4', etc -- so this worked fine. However, the g-sheets-api package wasn't getting the true Sheet at the correct index.
In this update, we've added another call to grab all the existing sheet data and correctly pull in the Sheet based at the number you supply.
Note this shouldn't be a breaking change for you, but best to be aware of how this sheet numbering business now operates before you throw caution to the wind and update all the things! 👍
Full Changelog: v2.1.3...v2.2.0
Contributors
Assets 2
Adds TypeScript support
- Adds TypeScript types (
*.d.ts) support - Updates various dependency packages
- Applies security updates and patches
Fixes for sheet name/number provision
Adds support for special symbols in sheet names
Adds support for Sheet names
Major rewrite to handle Sheet API v4 - Breaking change
- Adds supporting screenshot 17fde66
- Rewrites internal code to support Google Sheets API v4 ec42868
- Merge branch 'master' of https://github.com/bpk68/g-sheets-api ad60cba
- Remove trailing console statements 9582536
- Merge pull request #96 from bpk68/renovate/pin-dependencies 543f390
- Pin dependency parcel-bundler to 1.12.5 0729d69
Important, the
g-sheets-apipackage will work just as it does now so you shouldn't need to alter your existing code. However, you will need to get hold of your own Google Sheets API key and add it to the calling options asapiKey.
You can learn more about generating a Google Sheets API key here >>> https://developers.google.com/sheets/api/guides/authorizing
You may also need to adjust the public sharing of your Sheet, by reading through the README.md file in the package.
v1.5.1
- Remove cache from repo 713c556
- Update renovate.json 3a1902a
- Merge pull request #95 from bpk68/renovate/babel-monorepo a0985dd
- Update dependency @babel/core to v7.15.0 caa1059
- Update node support from node-fetch to cross-fetch package
- Alters internal GSheets call to pull in JSON over text feed
- Update README.md for node support
- Fix node demo load issue
v1.5.0
- Update renovate.json 3a1902a
- Merge pull request #95 from bpk68/renovate/babel-monorepo a0985dd
- Update dependency @babel/core to v7.15.0 caa1059
- Update node support from node-fetch to cross-fetch package
- Alters internal GSheets call to pull in JSON over text feed
- Update README.md for node support
- Fix node demo load issue