Python ---- 处理Excel
1. Ubuntu下相关的库的安装:
$ sudo apt-get install python-setuptools
$ sudo easy_install xlrd
$ sudo easy_install pyexcelerator
2. 库的介绍
2.1 xlrd
Library for developers to extract data from Microsoft Excel (tm) spreadsheet
files
Extract data from new and old Excel spreadsheets on any platform. Pure Python
(2.1 to 2.6). Strong support for Excel dates. Unicode-aware
2.2 pyexcelerator
pyExcelerator is a library for generating Excel 97/2000/XP/2003 and OpenOffice
Calc compatible spreadsheets. pyExcelerator has full-blown support for UNICODE
in Excel and Calc spreadsheets, allows using variety of formatting features,
provides interface to printing options of Excel and OpenOffice Calc.
pyExcelerator contains also Excel BIFF8 dumper and MS compound documents dumper.
Main advantage is possibility of generating Excel spreadsheets without COM
servers. The only requirement -- Python 2.4b2 or higher. From version 0.5
pyExcelerator can import data from Excel spreadsheets.
