Tuesday, September 13, 2011

Python and Excel Connectivity

Excel files are easy to work with using Python. The Python packages listed below are best available when you intent to access excel files without Excel installed or even on platforms other than Windows.

They are fast, reliable and open source.

Reading Excel Files :: XLRD
This python package is effective in order to read the content from inside an existing excel file.

Download


Writing Excel Files :: XLWT
This python package allows the writing of a new excel workbook.

Download

Modifying/Updating Existing Excel Files :: XLUTILS
This python package allows the capability to modify the content of an already existing Excel File.
This requires both XLRD and XLWT

Download


1 comment:

  1. The XLRD module to read excel workbook/spreadsheets now has support for the Excel 2007 (XLSX) format.

    Version :- 0.9.2

    ReplyDelete