Issue 698 in gdata-python-client: [ New Google Sheets]How can we get od? style worksheetid above "sheet2"?

37 views
Skip to first unread message

gdata-pyt...@googlecode.com

unread,
May 14, 2014, 11:21:40 PM5/14/14
to gdata-python-client-...@googlegroups.com
Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 698 by js...@rashiku1.com: [ New Google Sheets]How can we get od?
style worksheetid above "sheet2"?
http://code.google.com/p/gdata-python-client/issues/detail?id=698

In Old Spreadsheet, the following converting method (gid -> od?) has been
working.
http://stackoverflow.com/questions/11290337/how-to-convert-google-spreadsheets-worksheet-string-id-to-integer-index-gid

In New Google Sheets, gid specification has been changed as below:
sheet1 -> gid=0
sheet2 -> gid=[randomized numerical value over 8 digits]
sheet3 -> (same way with sheet2)

I would like to update cell in the worksheet I specified with worksheet id.
I tried the above converting method, but it doesn't work. It seems the
converting method doesn't execute in New Sheets.

Is there any alternative way?


--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

gdata-pyt...@googlecode.com

unread,
Aug 15, 2014, 8:06:10 AM8/15/14
to gdata-python-client-...@googlegroups.com

gdata-pyt...@googlecode.com

unread,
Oct 22, 2014, 3:27:47 AM10/22/14
to gdata-python-client-...@googlegroups.com

Comment #2 on issue 698 by mario.co...@webrepublic.ch: [ New Google
Sheets]How can we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

The conversion method does not work for new Google Sheets.

gdata-pyt...@googlecode.com

unread,
Oct 23, 2014, 6:19:01 AM10/23/14
to gdata-python-client-...@googlegroups.com

Comment #3 on issue 698 by Elvin....@gmail.com: [ New Google Sheets]How can
we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

i'm facing this particular issue as well with the new google
spreadsheets :( this post suggests that there is no easy way as it is
randomized:
https://productforums.google.com/d/msg/docs/VIQPvjRIswk/UoC2M1BB0esJ

the only way i can think of right now is to get the worksheet feeds and
parse the XML and work from there onwards...unless anybody else has a
better solution do share it!

gdata-pyt...@googlecode.com

unread,
Oct 23, 2014, 6:28:02 AM10/23/14
to gdata-python-client-...@googlegroups.com

Comment #4 on issue 698 by mario.co...@webrepublic.ch: [ New Google
Sheets]How can we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

@Elvin That is also the workaround I have implemented.

gdata-pyt...@googlecode.com

unread,
Nov 12, 2014, 12:30:15 PM11/12/14
to gdata-python-client-...@googlegroups.com

Comment #5 on issue 698 by axp1...@gmail.com: [ New Google Sheets]How can
we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

Has anyone figured this out yet ? I'm trying to get the worksheet id for
Sheet2 and on. But no luck yet.

gdata-pyt...@googlecode.com

unread,
Dec 10, 2014, 8:51:19 AM12/10/14
to gdata-python-client-...@googlegroups.com

Comment #6 on issue 698 by pablon...@gmail.com: [ New Google Sheets]How can
we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

Hi, I was facing the same problem and using the worksheet_id as the number
of sheet solved my issue.
Sheet 2 -> worksheet_id = 2
Sheet 3 -> worksheet_id = 3 and so on...

gdata-pyt...@googlecode.com

unread,
Dec 15, 2014, 8:54:00 AM12/15/14
to gdata-python-client-...@googlegroups.com

Comment #7 on issue 698 by vbaba...@gmail.com: [ New Google Sheets]How can
we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

i am also stuck with this problem - any solution/help would be appreciated

gdata-pyt...@googlecode.com

unread,
Dec 15, 2014, 8:56:35 AM12/15/14
to gdata-python-client-...@googlegroups.com

gdata-pyt...@googlecode.com

unread,
Dec 15, 2014, 6:16:01 PM12/15/14
to gdata-python-client-...@googlegroups.com

Comment #9 on issue 698 by vbaba...@gmail.com: [ New Google Sheets]How can
we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

could someone pls explain workaround for this problem - spent too many
hours and haven't figured out solution yet - thank you

gdata-pyt...@googlecode.com

unread,
Dec 15, 2014, 6:32:39 PM12/15/14
to gdata-python-client-...@googlegroups.com

Comment #10 on issue 698 by vbaba...@gmail.com: [ New Google Sheets]How can
we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

does above link work for new style google spreadsheets? looking for python
solution to iterate thru all worksheets - would really appreciate some help
(spent too many hrs and haven't been figure out solution yet) - thank you vm

gdata-pyt...@googlecode.com

unread,
Dec 15, 2014, 6:33:39 PM12/15/14
to gdata-python-client-...@googlegroups.com

Comment #11 on issue 698 by vbaba...@gmail.com: [ New Google Sheets]How can
we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

does solution on above link work for new style google spreadsheets? looking

gdata-pyt...@googlecode.com

unread,
Feb 23, 2015, 11:57:15 PM2/23/15
to gdata-python-client-...@googlegroups.com

Comment #12 on issue 698 by dra...@cashedge.com: [ New Google Sheets]How
can we get od? style worksheetid above "sheet2"?
https://code.google.com/p/gdata-python-client/issues/detail?id=698

This is really embarassing!!
Reply all
Reply to author
Forward
0 new messages