xlrd
Python Software Foundation
xlrd is a library for developers to extract data from Microsoft Excel (tm) .xls spreadsheet files. xlrd is a library for reading data and formatting information from Excel files in the historical .xls format. This library will no longer read anything other than .xls files. Ignores charts, macros, pictures, any other embedded object, including embedded worksheets, VBA modules, and formulas, but results of formula calculations are extracted, comments, hyperlinks, auto filters, advanced filters, pivot tables, conditional formatting, and data validation. Password-protected files are not supported and cannot be read by this library. From the command line, this will show the first, second, and last rows of each sheet in each file. xlrd is licensed under the BSD license.