search

kamawanu / googlecode-gdata-python-client

Automatically exported from code.google.com/p/gdata-python-client
1 stars 0 forks source link

[ New Google Sheets]How can we get od? style worksheetid above "sheet2"? #698

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
In Old Spreadsheet, the following converting method (gid -> od?) has been 
working.
http://stackoverflow.com/questions/11290337/how-to-convert-google-spreadsheets-w
orksheet-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?

Original issue reported on code.google.com by js...@rashiku1.com on 15 May 2014 at 3:21

GoogleCodeExporter commented 9 years ago 
http://stackoverflow.com/questions/11290337/how-to-convert-google-spreadsheets-w
orksheet-string-id-to-integer-index-gid

Original comment by bostikfo...@gmail.com on 15 Aug 2014 at 12:05

GoogleCodeExporter commented 9 years ago 
The conversion method does not work for new Google Sheets.

Original comment by mario.co...@webrepublic.ch on 22 Oct 2014 at 7:27

GoogleCodeExporter commented 9 years ago 
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!

Original comment by Elvin....@gmail.com on 23 Oct 2014 at 10:18

GoogleCodeExporter commented 9 years ago 
@Elvin That is also the workaround I have implemented.

Original comment by mario.co...@webrepublic.ch on 23 Oct 2014 at 10:27

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

Original comment by axp1...@gmail.com on 12 Nov 2014 at 5:29

GoogleCodeExporter commented 9 years ago 
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...

Original comment by pablon...@gmail.com on 10 Dec 2014 at 1:50

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Guys....

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

Original comment by mario.co...@webrepublic.ch on 15 Dec 2014 at 1:56

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
This is really embarassing!!

Original comment by dra...@cashedge.com on 24 Feb 2015 at 4:57