Solved! Go to Solution.
with open(filename, 'wb') as f: writer = csv.writer(f) writer.writerows(worksheet.get_all_values())
writer = csv.writer(open(filename, 'wb')) writer.writerows(worksheet.get_all_values())
import csv import gspread g = gspread.login('skiesgoinggreen@gmail.com', '???') docid = "0AgNp9UJ4CX93dHl3RW9GRXJDS3kxaXRJMGNqWmhQWVE" spreadsheet = g.open_by_key(docid) for i, worksheet in enumerate(spreadsheet.worksheets()): filename = docid + '-worksheet' + str(i) + '.csv' with open(filename, 'wb') as f: writer = csv.writer(f) writer.writerows(worksheet.get_all_values())
import csv import gspread g=gspread.login('skiesgoinggreen@gmail.com', 'XXXXXXXXXXXX') docid = "0AgNp9UJ4CX93dHl3RW9GRXJDS3kxaXRJMGNqWmhQWVE" spreadsheet = g.open_by_key(docid) for i, worksheet in enumerate(spreadsheet.worksheets()): filename = docid + '-worksheet' + str(i) + '.csv' with open(filename, 'wb') as f: writer = csv.writer(f) writer.writerows(worksheet.get_all_values())
with open(filename, 'wb') as f: writer = csv.writer(f) writer.writerows(worksheet.get_all_values())
writer = csv.writer(open(filename, 'wb')) writer.writerows(worksheet.get_all_values())