`

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.
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics