读写Excel文档

一般简单的读写Excel文档方法

import xlrd
import xlwt

excelfile1=xlrd.open_workbook(r'C:\Users\Evan\Desktop\jira_issues.xlsx')

sheet1=excelfile1.sheet_by_name('summary')

fieldname=[]
fieldvalue=[]
for i in range(8,20):

    fieldname.append(sheet1.cell(i,0).value)

    fieldvalue.append(sheet1.cell(i,1).value)

print(fieldname)
print(fieldvalue)

excelfile2=xlwt.Workbook(r'C:\DISK D\Python learning\files\example.xls')

sheet=excelfile2.add_sheet('test',cell_overwrite_ok=True)

for j in range(0,len(fieldvalue)):
    
    if fieldvalue[j]=='Y':
        sheet.write(0,j,fieldname[j])

excelfile2.save(r'C:\DISK D\Python learning\files\example.xls')