4 questions
2
votes
1
answer
99
views
how to get update-able sheet name in google sheets
is there a way how to get updateable sheet name of the active or any other sheet without using scripts - only native formulae allowed and no hardcoding
for example, in the spreadsheet there is a sheet ...
0
votes
1
answer
114
views
Unable to add a line chart with 3 series into a Google sheet using API
I have a project to monitorize some parameters with ESP32 (Arduino IDE sketch) and I save result into a gsheets. Every new day generate new sheet to save dates. After new sheet creation, I want to ...
0
votes
0
answers
86
views
Cannot load the data from the Gsheet in real phone
I make some android app that can input data and store it in Google sheets When I run it in the emulator, it work really well. I can input new data and it show the data in the sheets. But, when I ...
1
vote
3
answers
351
views
How to get total number of rows with data in a sheet using gsheets dart library?
Using the gsheets library, I can calculate the total number of rows in a specific sheet:
final sheet = ss.worksheetByTitle('test');
final rows = await sheet?.values.map.allRows();
final totalRows = ...