Fix issue with google sheets API
Budget: $10 – $30 USD
Hi I have a problem with google sheets API described here
https://stackoverflow.com/questions/69537680/how-to-get-raw-numbers-from-google-sheets-api
And to recap:
I have a simple function that gets data from a google sheet.
for example https://sheets.googleapis.com/v4/spreadsheets/1pSQ4W0GV85Z-6QrUx0UxVA3VCSHE3x93BT3c-R6mHZk/values/Form Responses 1!A1:AZ1000?valueRenderOption=UNFORMATTED_VALUE
I have a field there with long numbers, that google automatically displays in scientific notation like this
{
"range": "'Form Responses 1'!A1:F103",
"majorDimension": "ROWS",
"values": [
[
"cc"
],
[
4.3668413379866e+15
],
[
4.14809933325943e+15
]
]
}
I don't mind how its displayed in Sheets, as its never used directly. But in my API call I must be able to get the original/raw number.
PS. Changing the format in the sheets ui might help, but this has 2 issues:
It will require double and triple work for each field in each sheet, instead of fixing in the code that gets the data.
I tried it for testing, but it seems to ruin existing data, by changing also the raw "data-behind". Instead of only the display value. So I can't go that route anyway.
What I need from you:
.net code that gets the spreadsheet data with the correct number values, without scientific notation formatting. or any other formatting for that matter.
Thanks!
https://stackoverflow.com/questions/69537680/how-to-get-raw-numbers-from-google-sheets-api
And to recap:
I have a simple function that gets data from a google sheet.
for example https://sheets.googleapis.com/v4/spreadsheets/1pSQ4W0GV85Z-6QrUx0UxVA3VCSHE3x93BT3c-R6mHZk/values/Form Responses 1!A1:AZ1000?valueRenderOption=UNFORMATTED_VALUE
I have a field there with long numbers, that google automatically displays in scientific notation like this
{
"range": "'Form Responses 1'!A1:F103",
"majorDimension": "ROWS",
"values": [
[
"cc"
],
[
4.3668413379866e+15
],
[
4.14809933325943e+15
]
]
}
I don't mind how its displayed in Sheets, as its never used directly. But in my API call I must be able to get the original/raw number.
PS. Changing the format in the sheets ui might help, but this has 2 issues:
It will require double and triple work for each field in each sheet, instead of fixing in the code that gets the data.
I tried it for testing, but it seems to ruin existing data, by changing also the raw "data-behind". Instead of only the display value. So I can't go that route anyway.
What I need from you:
.net code that gets the spreadsheet data with the correct number values, without scientific notation formatting. or any other formatting for that matter.
Thanks!
Related categories:
Google APIs