GoogleSheets.jl
GoogleSheets.jl copied to clipboard
Question about reading CellData with GoogleSheets.jl
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/cells#celldata
looking at CellData like "note"
With GoogleSheets I can write a note on a cell a few ways using batch_update!
I haven't found a way to read a note on a cell.
same with format, is there a way to read, for example the background color a cell with GoogleSheets?
ok I guess i realized i can get notes using
GoogleSheets.gsheet_api_spreadsheet_get(client; spreadsheetId=range.spreadsheet.id,ranges=CellRange(spreadsheet, sheetName).range, fields="sheets/data/rowData/values/note")
is that the best way?