GoogleSheets.jl icon indicating copy to clipboard operation
GoogleSheets.jl copied to clipboard

Question about reading CellData with GoogleSheets.jl

Open 8steve8 opened this issue 1 year ago • 1 comments

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?

8steve8 avatar Dec 10 '23 08:12 8steve8

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?

8steve8 avatar Dec 10 '23 09:12 8steve8