Skip to content
Advertisement

Tag: google-sheets

“Invalid requests[0].updateCells: Invalid field” when using barchUpdate on googlespreadsheet API

So I was able to fix an error I had, but now I am getting an error for the field entered through the setFields method. I thought you could put any string, but it seems that it’s not the case at all. The documentation doesn’t seem to provide what might be the issue. I get the error: https://developers.google.com/resources/api-libraries/documentation/sheets/v4/php/latest/class-Google_Service_Sheets_GridRange.html The documentation

Get Cell Format from Google Sheet API

I’d like to retrieve the format/type of the cell that set in google sheet, for example Plain text, Number, Date, Time and etc from the Google Sheet API. Google Sheet format screenshot here. Google Sheet Sample I’m using the API from this Srijan’s reference, it only able to pull out the values of the cells, but I need the format

Advertisement