python修改excel数据的实例代码

在前面的文章中介绍了如何用python读写excel数据,今天再介绍一下如何用python修改excel数据。需要用到xlutils模块。下载地址为https://pypi.python.org/pypi/xlutils。下载后执行python setup.py install命令进行安装即可。具体使用代码如下:

代码如下:

#-*-coding:utf-8-*-from xlutils.copy import copy # http://pypi.python.org/pypi/xlutilsfrom xlrd import open_workbook # http://pypi.python.org/pypi/xlrdfrom xlwt import easyxf # http://pypi.python.org/pypi/xlwt

import sysreload(sys)sys.setdefaultencoding(‘utf-8’)

# 0 based (subtract 1 from excel row number)start_row = 404

ismal_index = 2#url所在列url_index = 12#domain所在列domain_index = 11#malinfo所在列malinfo_index = 9

file_path = “c:\\users\\***\\desktop\\20130514.xls”#formatting_info=true保存之前数据的格式rb = open_workbook(file_path,formatting_info=true)r_sheet = rb.sheet_by_index(0) # read only copy to introspect the filewb = copy(rb) # a writable copy (i can’t read values out of this, only write to it)w_sheet = wb.get_sheet(0) # the sheet to write to within the writable copy

malurl = ”’http://xbox.ooqqxx.com/res/ext.jar http://xbox.ooqqxx.com/res/stat.jar http://xbox.ooqqxx.com/pages/v.html http://xbox.ooqqxx.com/pages/extv.html http://xbox.ooqqxx.com/pages/r.html”’domain_info = “http://xbox.ooqqxx.com”malinfo = u”获取恶意url,写入配置文件中,下载恶意可执行程序。”

#r_sheet.nrows为总行数for row_index in range(start_row, r_sheet.nrows): #xlsvalue = r_sheet.cell(row_index, col_age_november).value w_sheet.write(row_index, ismal_index, u’是’) w_sheet.write(row_index, url_index, malurl) w_sheet.write(row_index, domain_index, domain_info) w_sheet.write(row_index, malinfo_index, malinfo)#wb.save(file_path + ‘.out’ + os.path.splitext(file_path)[-1])wb.save(“c:\\users\\***\\desktop\\2013.xls”)