http://code.activestate.com/recipes/users/4183853/2012-10-09T07:00:55-07:00ActiveState Code Recipes2012-10-09T07:00:55-07:00wei.Liuhttp://code.activestate.com/recipes/users/4183853/http://code.activestate.com/recipes/578283-read-tabular-data-from-excel-spreadsheets-the-fast/

<p style="color: grey"> Python recipe 578283 by <a href="/recipes/users/4183853/">wei.Liu</a> (<a href="/recipes/tags/database/">database</a>). </p> <p>Sometimes you get an Excel spreadsheet (say, from the marketing departement) and you want to read tabular data from it (i.e. a line with column headers and lines of data). There are many ways to do this (including ODBC + mxODBC), but the easiest way I've found is this one : provide a file name and a sheet name, and read the data !</p>