python 读写excel表格

本文主要是介绍python 读写excel表格，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

在python安装目录下安装easy-install，然后安装xlrd和xlwd模块

 

 

from xlwt import Workbook, Formula
import xlrd
from pyExcelerator import * 
 
w = Workbook()
ws = w.add_sheet('Sheet1')
 
fname = r'E:\1.xlsx'
bk = xlrd.open_workbook(fname)
shxrange = range(bk.nsheets)
sheet1 = bk.sheet_by_name("Sheet1")
nrows = sheet1.nrows
ncols = sheet1.ncols
print "nrows %d, ncols %d" % (nrows,ncols)

r = 0
for i in range(0,nrows):
    s = sheet1.cell_value(i,1).split(',')
    for j in range(0,len(s)):
        ws.write(r,0,sheet1.cell_value(i,0))
        ws.write(r,1,s[j])
        r = r + 1
       
w.save('E:\\a.xls')

 

这篇关于python 读写excel表格的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---