Iwark / spreadsheet

Google Go (golang) library for reading and writing spreadsheet files on Google Docs.
MIT License
382 stars 53 forks source link

How to add a new sheet? #29

Closed yipjustin closed 5 years ago

dkuebric commented 5 years ago

@yipjustin I couldn't find a way to do this in the publicly-documented Google Sheets API: https://developers.google.com/sheets/api/reference/rest/

However, I did find a way to create multiple sheets at spreadsheet creation time, which served my purposes: https://github.com/Iwark/spreadsheet/pull/32

zaddok commented 5 years ago

Technically this doesn't resolve the issue. Is a solution for this planned in the future?

Iwark commented 5 years ago

@zaddok Thank you for your reporting! I'll take a look at it soon!

yipjustin commented 5 years ago

seems like it can be done thru batchRequest with kind addSheet.

see: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request#addsheetrequest

zaddok commented 5 years ago

It would be awesome if it was added to this library.

Iwark commented 5 years ago

OK, it's now merged 👍 Thanks a lot for helping guys!

https://github.com/Iwark/spreadsheet/pull/33

zaddok commented 5 years ago

This is great, thanks!