1.打印excel的一列为列表表示
server.xls:
# encoding : utf-8 import xlrd xlsfile = u'C:\Python27\server.xls' data = xlrd.open_workbook(xlsfile) table = data.sheet_by_name(u'sheet2') ncols = table.ncols print ncols #for i in range(ncols): #print table.col_values(0) a = table.col_values(1) print a
打印结果：
14
[u'S_18.21', 0.8, 0.98, 0.92, 0.705, 1.0]
2.打印txt文档的一列为列表表示
ex.txt:
0.76
0.76
0.76
0.76
#encoding:utf8
import xlrd
import xlwt
class openexcel():
def wexcel(self,infile,outefile):
rfile=open(infile,'r')
buf=rfile.read().split('\n')
print buf
rfile.close()
#w=xlwt.Workbook()
#sheet=w.add_sheet('sheet1')
#for i in range(len(buf)):
#print buf[i]
#sheet.write(i+1,1,buf[i].decode('utf8'))
#w.save(outefile)
if __name__ == '__main__':
t=openexcel()
t.wexcel('ex.txt','server.xls')打印结果：
['0.76', '0.76', '0.76', '0.76']
3.前面两例的综合，2的打印结果替换1的打印结果相应数据
#encoding:utf8
import xlrd
import xlwt
class openexcel():
def wexcel(self,infile,outefile):
rfile=open(infile,'r')
buf=rfile.read().split('\n')
return buf
rfile.close()
xlsfile = u'C:\Python27\server.xls'
data = xlrd.open_workbook(xlsfile)
table = data.sheet_by_name(u'sheet2')
excel_data = table.col_values(1)
if __name__ == '__main__':
t=openexcel()
txt_data = t.wexcel('ex.txt','server.xls')
excel_data[1:] = txt_data
print excel_data打印结果：
[u'S_18.21', '0.76', '0.76', '0.76', '0.76'] #红色为替换部分
4.多个txt文件写入一个excel：
ex0.txt:
Server
/
/backup
/project
memory
swap
ex1.txt:
0.71
0.71
0.71
0.71
0.71
ex2.txt:
S_18.22
0.72
0.72
0.72
0.72
#encoding:utf8
import xlrd
import xlwt
class openexcel():
def wexcel(self,l1,l2,l3,l4,outefile):
rfile1=open(l1,'r')
rfile2=open(l2,'r')
rfile3=open(l3,'r')
rfile4=open(l4,'r')
buf1=rfile1.read().split('\n')
buf2=rfile2.read().split('\n')
buf3=rfile3.read().split('\n')
buf4=rfile4.read().split('\n')
print buf1,buf2,buf3,buf4
rfile1.close()
rfile2.close()
w=xlwt.Workbook()
sheet=w.add_sheet(u'sheet2')
for i in range(len(buf1)):
#print buf1[i]
sheet.write(i,0,buf1[i].decode('utf-8'))
for i in range(len(buf2)):
sheet.write(i,1,buf2[i].decode('utf-8'))
for i in range(len(buf3)):
sheet.write(i,2,buf3[i])
for i in range(len(buf4)):
sheet.write(i,3,buf4[i].decode('utf-8'))
w.save(outefile)
if __name__ == '__main__':
t=openexcel()
t.wexcel(u'ex0.txt','ex1.txt','ex2.txt','ex3.txt','server.xls')server.xls输出结果：
