Grabbing Google Docs information with a Python - Revision history

Public: /* GoogleSpreadsheet Class */

2011-09-14T16:08:24Z

GoogleSpreadsheet Class

← Older revision		Revision as of 16:08, 14 September 2011
Line 33:		Line 33:
	''' An iterable google spreadsheet object. Each row is a dictionary with an entry for each field, keyed by the header. GData libraries from Google must be installed.'''		''' An iterable google spreadsheet object. Each row is a dictionary with an entry for each field, keyed by the header. GData libraries from Google must be installed.'''

	def __init__(self, spreadsheet_id, worksheet_id, user='abc@place.org', password='~~2312324~~', source=''):		def __init__(self, spreadsheet_id, worksheet_id, user='abc@place.org', password='xyxyxy', source=''):
	gd_client = gdata.spreadsheet.service.SpreadsheetsService()		gd_client = gdata.spreadsheet.service.SpreadsheetsService()
	gd_client.email = user		gd_client.email = user

2011-09-14T16:07:46Z

Brief introduction to the code

← Older revision		Revision as of 16:07, 14 September 2011
Line 72:		Line 72:
	==Brief introduction to the code==		==Brief introduction to the code==

	You may need to know some elementary Python and HTML scripting. ~~The~~ code can be found [http://archive.gersteinlab.org/misc/scriptSkeleton.py here].		You may need to know some elementary Python and HTML scripting. A sanitized code can be found
			[http://archive.gersteinlab.org/misc/scriptSkeleton.py here].

	<br>There are a number of functions in the script in addition to the function:		<br>There are a number of functions in the script in addition to the function:

2011-09-14T16:05:35Z

Brief introduction to the code

← Older revision		Revision as of 16:05, 14 September 2011
Line 72:		Line 72:
	==Brief introduction to the code==		==Brief introduction to the code==

	You may need to know some elementary Python and HTML scripting.		You may need to know some elementary Python and HTML scripting. The code can be found [http://archive.gersteinlab.org/misc/scriptSkeleton.py here].

	<br>There are a number of functions in the script in addition to the function:		<br>There are a number of functions in the script in addition to the function:

2011-09-14T15:41:25Z

@@ Line 2: / Line 2: @@
 In order to use the GoogleSpreadsheet class, a number of dependencies must be met.  Assuming you already have Linux and Python installed, follow these [http://code.google.com/apis/gdata/articles/python_client_lib.html#dependencies instructions] to enable the Google Data API.
 ==Example Usage==
@@ Line 15: / Line 14: @@
    print row["lastname"]
 </pre></code>
 ==GoogleSpreadsheet Class==
@@ Line 90: / Line 69: @@
 		return len(self.rows)
 </pre></code>

2011-09-14T15:40:39Z

Code

← Older revision		Revision as of 15:40, 14 September 2011
Line 36:		Line 36:
	The main function is located at the bottom of the script, and it basically prints the HTML in sequential order (header section footer...)		The main function is located at the bottom of the script, and it basically prints the HTML in sequential order (header section footer...)

	==~~Code~~==		==GoogleSpreadsheet Class==

			Python code to import Google Spreadsheet objects. Save below text as GoogleSpreadsheet.py, then in your python code import GoogleSpreadsheet.

	~~===Google Docs API===~~
	<code><pre>		<code><pre>
	try:		try:

2011-09-14T15:40:19Z

GoogleSpreadsheet Class

← Older revision		Revision as of 15:40, 14 September 2011
Line 3:		Line 3:
	In order to use the GoogleSpreadsheet class, a number of dependencies must be met. Assuming you already have Linux and Python installed, follow these [http://code.google.com/apis/gdata/articles/python_client_lib.html#dependencies instructions] to enable the Google Data API.		In order to use the GoogleSpreadsheet class, a number of dependencies must be met. Assuming you already have Linux and Python installed, follow these [http://code.google.com/apis/gdata/articles/python_client_lib.html#dependencies instructions] to enable the Google Data API.


	~~==GoogleSpreadsheet Class==~~

	~~Python code to import Google Spreadsheet objects. Save below text as GoogleSpreadsheet.py, then in your python code import GoogleSpreadsheet.~~

	==Example Usage==		==Example Usage==

2011-09-14T15:39:58Z

Header

2011-09-14T15:38:25Z

Brief introduction to the code

← Older revision		Revision as of 15:38, 14 September 2011
Line 24:		Line 24:
	You may need to know some elementary Python and HTML scripting.		You may need to know some elementary Python and HTML scripting.

	*Brief introduction to the different sections<br>		<br>There are a number of functions in the script in addition to the function:
	There are a number of functions in the script in addition to the function:
	divideSpreadsheet		divideSpreadsheet
	- looks in the 'category' column and splits the spreadsheet into graduate students, postdocs, staff, research scientists and undergrads. <br>		- looks in the 'category' column and splits the spreadsheet into graduate students, postdocs, staff, research scientists and undergrads. <br>

2011-09-14T15:38:00Z

Code

2011-09-14T15:35:41Z

@@ Line 19: / Line 19: @@
    print row["lastname"]
 </pre></code>
 ==Code==
@@ Line 72: / Line 93: @@
 		return len(self.rows)
 </pre></code>