xlrd

最新推荐文章于 2024-06-18 16:48:36 发布

weixin_34014555

最新推荐文章于 2024-06-18 16:48:36 发布

阅读量61

点赞数

CC 4.0 BY-SA版权

文章标签： python

原文链接：http://www.cnblogs.com/jian-pan/p/6540510.html

本文介绍了一种使用Python进行Excel文件数据处理的方法，包括读取、格式转换及写入等功能。通过对a.xlsx和b.xlsx两个文件的操作，实现了数据的批量处理，并将处理后的数据保存到新的Excel文件中。

#coding : utf-8
import numpy
import xlrd
import xlwt
import sys
reload(sys)
sys.setdefaultencoding( "utf-8" )
aworkbook = xlrd.open_workbook(r'a.xlsx')
bworkbook = xlrd.open_workbook(r'b.xlsx')
sheet1 = aworkbook.sheet_by_index(0)
sheet2 = bworkbook.sheet_by_index(0)
len1 = len(sheet2.col_values(2))
print len1
data = []
for i in range(4,len1):
    tmp = sheet2.row_values(i)
    for j in range(len(tmp)):
        tmp[j] = str(tmp[j])
    tmp1 = tmp[:]
    data.append(tmp1)
# for i in data:

print data
with open('r','w') as f:
    for i in data:
        f.write(','.join(i))
        f.write('\n')
f = xlwt.Workbook()
sheet = f.add_sheet('sheet1')
for i in range(0, len(data)):
    for j in range(len(data[i])):
        sheet.write(i,j,data[i][j].decode('utf-8'))
try:
    f.save('demo1.xlsx')
except Exception,e:
    print e
# row3 = sheet2.col_values(2)
# col2 = sheet2.row_values(4)
# # print row3
#
# print row3
# print len(col2)
# for i in range(len(col2)):
#     col2[i] = str(col2[i])
# r = ','.join(col2)
# r1 = ','.join(row3)
# r.encode('utf-8')
# r1.encode('utf-8')
# empList = r.split(',')
# print empList