基于Python第三方库实现Excel读写

Implementation of Reading and Writing for Excel Based on the Third Party Library of Phthon

介绍了基于Python第三方库pyExcelerator与xlrd实现Excel读写的方法,着重介绍了xlrd读取Excel内容和pyExcelerator修改与生成带格式的Excel文件的实现细节。pyExcelerator与xlrd可以广泛应用于部署在非Windows操作系统下的应用程序,方便程序调用Excel报表信息,并进行二次编辑或者生成的操作,特别是一些系统自动导出Excel文件、网络游戏Excel报表等场合,具有极大的应用价值。

This paper introduces a method based on Python third library pyExeelerator and xlrd to realize Excel opctions, and emphatically introduces the implementation details of reading Excel contents and producing excel files with format. PyExcelera- tor and xlrd library widely used on the deployment of applications on non windows operating system, for the program can easily reading and writing excel information, and the operation of correcting or creating, especially some system automatic export Ex- cel files, network game excel report form and so on occasions, and has great application value.