Using openpyxl to read file from memory

by

In the docs for load_workbook it says:

#:param filename: the path to open or a file-like object

..so it was capable of it all the time. It reads a path or takes a file-like object.
I only had to convert my file-like object returned by urlopen, to a bytestream with:

from io import BytesIO
wb = load_workbook(filename=BytesIO(input_excel.read()))

and I can read every piece of data in my Google-spreadsheet.

More Related Contents:

  1. Export a list of stock prices to excel
  2. How to write to an existing excel file without overwriting data (using pandas)?
  3. Writing to an Excel spreadsheet
  4. Convert Excel style date with pandas
  5. How to convert a given ordinal number (from Excel) to a date
  6. Editing workbooks with rich text in openpyxl
  7. Running an Excel macro via Python?
  8. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  9. append dataframe to excel with pandas
  10. How to open a password protected excel file using python?
  11. pandas xlsxwriter, format table header – not sheet header
  12. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  13. .xlsx and xls(Latest Versions) to pdf using python
  14. Convert date from excel in number format to date format python [duplicate]
  15. How to obtain sheet names from XLS files without loading the whole file?
  16. Calling python script from excel/vba
  17. Python: Open Excel Workbook using Win32 COM Api
  18. Merge rows based on value (pandas to excel – xlsxwriter)
  19. Write to StringIO object using Pandas Excelwriter?
  20. Putting many python pandas dataframes to one excel worksheet
  21. Python openpyxl data_only=True returning None
  22. How do I call an Excel macro from Python using xlwings?
  23. Insert row into Excel spreadsheet using openpyxl in Python
  24. Pandas: Reading Excel with merged cells
  25. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  26. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  27. Get cell color from .xlsx
  28. Export Charts from Excel as images using Python
  29. django excel xlwt
  30. Openpyxl max_row and max_column wrongly reports a larger figure

Leave a Comment