import xlrd import xlwt import os def get_path(): return os.getcwd() def get_dir(): return os.listdir(os.getcwd()) if __name__=="__main__": workbook=xlwt.Workbook() sheet=workbook.add_sheet("first sheet",cell_overwrite_ok=True) font = xlwt.Font() font.blod = True pattern_top = xlwt.Pattern() pattern_top.pattern = xlwt.Pattern.SOLID_PATTERN pattern_top.pattern_fore_colour = 5 style = xlwt.XFStyle() style.font = font style.pattern = pattern_top #sheet.write_merge(0,1,0,3,'测试测试测试',style) #合并单元格 for i in range(0,9): # 行 for j in range(0,i+1): sheet.write(i,j,str(i+1)+"X"+str(j+1)+"="+str((i+1)*(j+1)),style) workbook.save(os.getcwd()+"\\test.xls")