Python ---- 处理Excel

最新推荐文章于 2012-03-06 22:10:05 发布

greybeard

最新推荐文章于 2012-03-06 22:10:05 发布

阅读量74

点赞数

分类专栏： python 文章标签： python

本文链接：https://blog.csdn.net/greybeard/article/details/84158675

版权

python 专栏收录该内容

85 篇文章 0 订阅

订阅专栏

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.