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

[gdata-pyt...@googlecode.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]

Comment #1 on issue 698 by bostikfo...@gmail.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

http://stackoverflow.com/questions/11290337/how-to-convert-google-spreadsheets-worksheet-string-id-to-integer-index-gid

[gdata-pyt...@googlecode.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]

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]

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]

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]

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]

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]

Comment #8 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

Guys....

http://stackoverflow.com/questions/11290337/how-to-convert-google-spreadsheets-worksheet-string-id-to-integer-index-gid

[gdata-pyt...@googlecode.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]

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]

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]

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!!