title: Gspread export spreadsheet to filesystem with formatting
body: <p>I need to download the Google spreadsheets on filesystem, I am using Gspread to read the files from Google Drive which works fine.</p>
  
  <p>I tried exporting to CSV but this ofcourse discards the formatting.</p>
  
  <pre><code>    json_key = json.load(open('/googleDriveCredentials.json'))
      scope = ['https://spreadsheets.google.com/feeds']
      credentials = SignedJwtAssertionCredentials(json_key['client_email'], json_key['private_key'], scope)
      gc = gspread.authorize(credentials)
      wks = gc.openall()
  
      # processing first workbook
      spreadsheet = wks[1] 
  
      # Creating CSV file which doesn't preserve formatting
      for i, worksheet in enumerate(spreadsheet.worksheets()):
          filename = 'somefile' + str(i) + '.csv'
          with open(filename, 'wb') as f:
              writer = csv.writer(f)
              writer.writerows(worksheet.get_all_values())  
  </code></pre>
  
  <p>I am wondering if I can do something like this </p>
  
  <pre><code>worksheet.export("/myFolder")
  </code></pre>