使用pyExcelerator输出Excel文件

本文只介绍最pyExcelerator中最基本的功能：添加worksheet，向cell中输出值。

首先是pyExcelerator的安装，下载地址为http://sourceforge.net/projects/pyexcelerator/。下载文件解压后，运行setup.py install即可成功安装。

下面是程序：

import os
import pyExcelerator  # import a package

workDir = r"."

if __name__ == '__main__':

    book = pyExcelerator.Workbook() #declare a workbook instance

    for i in range(0, 10):
        st = book.add_sheet("sheet" + str(i))   #add a new worksheet instance, the parameter is the sheet name
        for lineNo in range(0, 10):
            for colNo in range(0, 10):
                st.write(lineNo, colNo, str(lineNo) + "---" + str(colNo))   # write a str value to the (lineNo, colNo) cell
                
    book.save(os.path.join(workDir, "output.xls"))  #must be 'xls', 'xlsx' is not supported

 

 

大功告成！