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')