对于使用Python从Google文档下载电子表格感兴趣的读者，本文将提供您所需要的所有信息，我们将详细讲解pythongooglesheet，并且为您提供关于GoogleCSV解析Google电子表

对于使用Python从Google文档下载电子表格感兴趣的读者，本文将提供您所需要的所有信息，我们将详细讲解python google sheet，并且为您提供关于Google CSV解析Google电子表格并获取单元格颜色？、Google 电子表格 - 负数到零、Google文档电子表格转换为JSON、Google表格应用脚本可从Google表格内部生成自定义电子邮件的宝贵知识。

• 使用Python从Google文档下载电子表格（python google sheet）
• Google CSV解析Google电子表格并获取单元格颜色？
• Google 电子表格 - 负数到零
• Google文档电子表格转换为JSON
• Google表格应用脚本可从Google表格内部生成自定义电子邮件

使用Python从Google文档下载电子表格（python google sheet）

给定键和工作表ID（gid），您能否生成一个Python示例，说明如何下载Google Docs电子表格？我不能

我已经搜索过API的版本1，版本2和版本3。我没有运气，我无法弄清楚他们编译过的类似ATOM的供稿API，gdata.docs.service.DocsService._DownloadFile私有方法说我未经授权，而且我不想自己编写整个Google
Login身份验证系统。由于挫败感，我要面对自己。

我有一些电子表格，我想这样访问它们：

username = ''mygooglelogin@gmail.com''password = getpass.getpass()def get_spreadsheet(key, gid=0):    ... (help!) ...for row in get_spreadsheet(''5a3c7f7dcee4b4f''):    cell1, cell2, cell3 = row    ...

请保存我的脸。

更新1： 我已经尝试了以下方法，但是没有任何组合Download()或Export()似乎奏效。（DocsService
此处的文档）

import gdata.docs.serviceimport getpassimport osimport tempfileimport csvdef get_csv(file_path):  return csv.reader(file(file_path).readlines())def get_spreadsheet(key, gid=0):  gd_client = gdata.docs.service.DocsService()  gd_client.email = ''xxxxxxxxx@gmail.com''  gd_client.password = getpass.getpass()  gd_client.ssl = False  gd_client.source = "My Fancy Spreadsheet Downloader"  gd_client.ProgrammaticLogin()  file_path = tempfile.mktemp(suffix=''.csv'')  uri = ''http://docs.google.com/feeds/documents/private/full/%s'' % key  try:    entry = gd_client.GetDocumentListEntry(uri)    # XXXX - The following dies with RequestError "Unauthorized"    gd_client.Download(entry, file_path)    return get_csv(file_path)  finally:    try:      os.remove(file_path)    except OSError:      pass

答案1

如果有人遇到这种情况寻求快速解决方案，这是另一个（当前）不依赖gdata客户端库的解决方案：

#!/usr/bin/pythonimport re, urllib, urllib2class Spreadsheet(object):    def __init__(self, key):        super(Spreadsheet, self).__init__()        self.key = keyclass Client(object):    def __init__(self, email, password):        super(Client, self).__init__()        self.email = email        self.password = password    def _get_auth_token(self, email, password, source, service):        url = "https://www.google.com/accounts/ClientLogin"        params = {            "Email": email, "Passwd": password,            "service": service,            "accountType": "HOSTED_OR_GOOGLE",            "source": source        }        req = urllib2.Request(url, urllib.urlencode(params))        return re.findall(r"Auth=(.*)", urllib2.urlopen(req).read())[0]    def get_auth_token(self):        source = type(self).__name__        return self._get_auth_token(self.email, self.password, source, service="wise")    def download(self, spreadsheet, gid=0, format="csv"):        url_format = "https://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=%s&exportFormat=%s&gid=%i"        headers = {            "Authorization": "GoogleLogin auth=" + self.get_auth_token(),            "GData-Version": "3.0"        }        req = urllib2.Request(url_format % (spreadsheet.key, format, gid), headers=headers)        return urllib2.urlopen(req)if __name__ == "__main__":    import getpass    import csv    email = "" # (your email here)    password = getpass.getpass()    spreadsheet_id = "" # (spreadsheet id here)    # Create client and spreadsheet objects    gs = Client(email, password)    ss = Spreadsheet(spreadsheet_id)    # Request a file-like object containing the spreadsheet''s contents    csv_file = gs.download(ss)    # Parse as CSV and print the rows    for row in csv.reader(csv_file):        print ", ".join(row)

Google CSV解析Google电子表格并获取单元格颜色？

<?
$id = ''1_8xheFjRuwofge-6SmHdawe2A8OtbF1meEfu6Bp149U'';
$gid = ''532089414'';
$range = ''A2:A9999'';
 
$csv = file_get_contents(''https://docs.google.com/spreadsheets/d/'' . $id . ''/export?format=csv&gid='' . $gid . ''&range='' . $range);
$csv = explode("\r\n",$csv);
$array = array_map(''str_getcsv'',$csv);
 
print_r($array);
?>

=IF(K69*0,09<0; 0; K69*0,09)

<script src="http://spreadsheets.google.com/feeds/feed/1SKI5773_68HiSve1fsz7fr4gotjFWHB7KBuVsOlLz6I/worksheet/public/basic?alt=json-in-script&callback=importGSS"></script><script type="text/javascript">    function importGSS(json) {        console.log(''finished'');    }</script>

<script src="https://spreadsheets.google.com/feeds/list/1SKI5773_68HiSve1fsz7fr4gotjFWHB7KBuVsOlLz6I/od6/public/values?alt=json-in-script&callback=importGSS"></script>

function myFunction() {

  var ID   = '';                                          // ID of your spreadsheet
  var copy = DriveApp.getFileById(ID).makeCopy();         // make a copy of the spreadsheet
  var ss   = SpreadsheetApp.openById(copy.getId())        // open the copy

  // convert all formulas into static values
  var range = ss.getActiveSheet().getDataRange();  // get data range
  var values = range.getDisplayValues();           // get all displayed values in the range
  range.setValues(values);                         // paste the values back
  
  while (ss.getSheets().length>1) ss.deleteSheet(ss.getSheets()[1]); // remove all sheets except the first one
  
  DriveApp.createFile(ss.getBlob().setName('sheet.pdf')); // make a PDF file
  copy.setTrashed(true);                                  // delete the copy

}