Reading/parsing Excel (xls) files with Python [closed]

by

I highly recommend xlrd for reading .xls files. But there are some limitations(refer to xlrd github page):

Warning

This library will no longer read anything other than .xls files. For
alternatives that read newer file formats, please see
http://www.python-excel.org/.

The following are also not supported but will safely and reliably be
ignored:

- Charts, Macros, Pictures, any other embedded object, including embedded worksheets.
- VBA modules
- Formulas, but results of formula calculations are extracted.
- Comments
- Hyperlinks
- Autofilters, advanced filters, pivot tables, conditional formatting, data validation

Password-protected files are not supported and cannot be read by this
library.

voyager mentioned the use of COM automation. Having done this myself a few years ago, be warned that doing this is a real PITA. The number of caveats is huge and the documentation is lacking and annoying. I ran into many weird bugs and gotchas, some of which took many hours to figure out.

UPDATE: For newer .xlsx files, the recommended library for reading and writing appears to be openpyxl (thanks, Ikar Pohorský).

More Related Contents:

  1. xls to csv converter
  2. Get formula from Excel cell with python xlrd
  3. How to make python create variables, without the user creating the variables?
  4. how to reverse a string number in python with for loop
  5. Sum the digits of a number
  6. How do I tell Python to convert integers into words
  7. python re.sub group: number after \number
  8. How to change plot background color?
  9. How to declare an array in Python?
  10. Interweaving two numpy arrays
  11. bs4.FeatureNotFound: Couldn’t find a tree builder with the features you requested: lxml. Do you need to install a parser library?
  12. Convert from ASCII string encoded in Hex to plain ASCII?
  13. How to find the min/max value of a common key in a list of dicts?
  14. Do something every x (milli)seconds in pygame
  15. How to use dot notation for dict in python?
  16. ImportError on python 3, worked fine on python 2.7
  17. Convert spark DataFrame column to python list
  18. Django URL Redirect
  19. Mutli-threading python with Tkinter
  20. How can I normalize a URL in python
  21. Matplotlib: draw grid lines behind other graph elements
  22. Why does Python installed via Homebrew not include Tkinter
  23. Python 3 UnicodeDecodeError: ‘charmap’ codec can’t decode byte 0x9d
  24. How to compare each item in a list with the rest, only once?
  25. How do I extend a python module? Adding new functionality to the `python-twitter` package
  26. How do I draw a grid onto a plot in Python?
  27. Python numpy: cannot convert datetime64[ns] to datetime64[D] (to use with Numba)
  28. Slicing multiple ranges of columns in Pandas, by list of names
  29. Updating Python on Mac
  30. reading multiple files contained in a zip file with pandas

Leave a Comment