xlrd

#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