title: Using openpyxl to read file from memory
body: <p>I downloaded a google-spreadsheet as an object in python.</p>
  
  <p>How can I use openpyxl use the workbook without having it to save to disk first?</p>
  
  <p>I know that xlrd can do this by:</p>
  
  <pre><code>book = xlrd.open_workbook(file_contents=downloaded_spreadsheet.read())
  </code></pre>
  
  <p>with "downloaded_spreadsheet" being my downloaded xlsx-file as an object.</p>
  
  <p>Instead of xlrd, I want to use openpyxl because of better xlsx-support(I read).</p>
  
  <p>I'm using this so far...</p>
  
  <pre><code>#!/usr/bin/python
  
      import openpyxl
      import xlrd
      # which to use..?
  
  
  import re, urllib, urllib2
  
  class Spreadsheet(object):
      def __init__(self, key):
          super(Spreadsheet, self).__init__()
          self.key = key
  
  class 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="xls"):
  
          url_format = "https://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=%s&amp;exportFormat=%s&amp;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__":
  
  
  
      email = "........@gmail.com" # (your email here)
      password = '.....'
      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
      downloaded_spreadsheet = gs.download(ss)
  
  
      # book = xlrd.open_workbook(file_contents=downloaded_spreadsheet.read(), formatting_info=True)
  
      #It works.. alas xlrd doesn't support the xlsx-funcionality that i want...
      #i.e. being able to read the cell-colordata..
  </code></pre>
  
  <p>I hope anyone can help because I'm struggling for months to get the color-data from given cell in google-spreadsheet. (I know the google-api doesn't support it..)</p>