search

flyfire / googlecl

Automatically exported from code.google.com/p/googlecl
0 stars 0 forks source link

Spreadsheet tab manipulation #266

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
===NOTE===
If you're asking for a new service that isn't supported by gdata-python-
client, this will immediately get flagged as WontFix.
==========

What service (Calendar, Docs, Picasa) should be enhanced?
Docs
What is the enhancement?
Spreadsheet tab "sheets" manipulation via a flag on the cli would be a great 
feature. 
When editing a document I am only able to edit "sheet1" in csv

google docs edit --editor=vim --title="blah" --format=csv --sheet=7

Thank you.

Original issue reported on code.google.com by brandonn...@gmail.com on 23 Aug 2010 at 9:32

GoogleCodeExporter commented 8 years ago 
It would be very nice!

Original comment by ginermail@gmail.com on 24 Oct 2010 at 4:21

GoogleCodeExporter commented 8 years ago 
Yes, getting data from several sheets is needed.

Original comment by ove...@gmail.com on 24 Oct 2010 at 4:29

GoogleCodeExporter commented 8 years ago 
Well it wasn't hard to find where to hack it to get a different sheet (grid / 
gid)

src/googlecl/docs/client.py
def export(self, entry_or_id_or_url, file_path, gid=None, auth_token=None,

change it to

def export(self, entry_or_id_or_url, file_path, gid=1, auth_token=None,

shows you can easily get them by their grid id, no idea how to map that to a 
name, but the gdata API doc seems to suggest they're stable numbers.

Original comment by j...@bragi0.com on 6 Oct 2011 at 11:45

GoogleCodeExporter commented 8 years ago 
it would also be nice to be able to get a list of all sheets/tags with names.

Original comment by sam.stei...@gmail.com on 24 Apr 2012 at 8:59

GoogleCodeExporter commented 8 years ago 
I would love to be able to do a get on a spreadsheet, save it as csv format, 
and automatically have it save each sheet as ParentFile-sheet1-Summary.csv, 
ParentFile-sheet2-data.csv etc.

Original comment by andgu...@gmail.com on 12 Nov 2012 at 9:14

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
I patched this into a local build. Diff is attached. Hope this helps someone.

Original comment by alexx1...@gmail.com on 4 Mar 2014 at 10:59

Attachments:

GoogleCodeExporter commented 8 years ago 
Thanks for the patch!

Original comment by jh...@google.com on 5 Mar 2014 at 12:08

GoogleCodeExporter commented 8 years ago 
FINALLY! :D Thanks a bunch, Alex!

Original comment by MazJal...@gmail.com on 5 Mar 2014 at 5:44

GoogleCodeExporter commented 8 years ago 
Hi, I an not a programmer expert. If I want to apply this patch, what do I need 
to do?
Thanks

Original comment by sze...@gmail.com on 20 Mar 2014 at 7:21

GoogleCodeExporter commented 8 years ago 
Hi szeevs,
Please take a look here:
http://stackoverflow.com/questions/10333712/how-to-make-and-apply-svn-patch

Original comment by MazJal...@gmail.com on 20 Mar 2014 at 7:44

GoogleCodeExporter commented 8 years ago 
So I need to download the source code, apply the patch and then re-coompile the 
whole thing?

Original comment by sze...@gmail.com on 20 Mar 2014 at 7:55

GoogleCodeExporter commented 8 years ago 
Yeah. It isn't as bad as it sounds, though :)

Original comment by MazJal...@gmail.com on 20 Mar 2014 at 7:56

GoogleCodeExporter commented 8 years ago 
I've committed your patch.  Thanks for submitting it, and sorry for the delay!

Original comment by list...@gmail.com on 1 Jul 2014 at 3:43