CODEWITHSUNDEEP
phpgoogle-drive-apigoogle-sheets-api
enfix
enfix

Reputation: 6970

Google Drive API using worksheet

I use update() function of Google Drive API to update (with convert=true parameter) a csv file to google drive.
The result is an updated Google Spreadsheet (single worksheet)

Can I update a specificied worksheet of the file (passing the ID) ?
Every update call create a different worksheet (different ID) and I don't need it changes.
I have this problem because an external app read this file using google file ID and worksheet ID.

I use PHP API.

Thanks all

Upvotes: 2

Views: 101

Answers (1)

Zig Mandel
Zig Mandel

Reputation: 19835

the api (or by url) does not support converting a csv into an existing spreadsheet.

you could instead convert into a new sheet and then use the spreadsheet api to copy the sheet data into your spreadsheet. you can also skip the csv upload step and directly parse and write to the existing sheet using that api.

Upvotes: 1

Related Questions