关于xlwt模块中 write(r,c)方法中的 R与C
import xlwt
def write_excel():
f = xlwt.Workbook() #cchaungjian gongzuobu
sheet1 = f.add_sheet(u'sheet1',cell_overwrite_ok=True)
# write content
row0 = [u'id',u'name',u'gender',u'birthdate'] #为什么要加上 u
#生成di 0 hang
for i in range(0,len(row0)):
sheet1.write(0,i,row0[i])
row1 = [u'1',u'zhangsan',u'nan']
row2 = [u'2',u'lisi',u'nv']
date = '1990-01-04'
# 生成第一行
for i in range(0,len(row1)):
sheet1.write(1,i,row1[i])
# shencgehng第二行
for i in range(0,len(row2)):
sheet1.write(2,i,row2[i])
# 写入合并的单元格数据1990-01-04
sheet1.write_merge(1,2,3,3,date)
f.save(r'E:\PyCharmContent\named1\拉勾网爬取职位名称信息\doc\demo1.xls')
print "Successful it is!"
if __name__ == "__main__":
write_excel()
以上代码的展示如下:
write(r,c):r:row c: col