googleapis / googleapis/google-api-nodejs-client
Google sheet api valueRenderOption doesn't work properly
- Vorherrschende Sprache
- TypeScript
- Sterne
- 12.2k
- Forks
- 2k
- Ø Merge
- 1 T. 9 Std.
- Gemergte PRs (30 T.)
- 24
Beschreibung
1) Is this a client library issue or a product issue?
- It looks like the library issue as it works fine with product direct API
2) Did someone already solve this?
- No
3) Do you have a support contract?
- No
#### Environment details
- OS: Mac
- Node.js version: v18.16.0
- npm version: 9.5.1
- `googleapis` version: 128.0.0
#### Steps to reproduce
1. I tried to fetch spreadsheet values using the below method. but it returns numeric values as it is, when I use the google API Explorer, it returns all the values as strings. I want to get all the values as strings in this case.
```ts
sheetsApi.spreadsheets.values.get({
spreadsheetId,
range,
valueRenderOption: 'FORMATTED_VALUE',
})
```
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get
Beitragsleitfaden
Bewertung
Dieses Issue wurde noch nicht bewertet.