PYTHON(8)python导出excel

def write_to_excel_mx():
            try:
                wb = openpyxl.Workbook()
                sheetnames = wb.get_sheet_names()
                sheet = wb.get_sheet_by_name(sheetnames[0])
                write_data(sheet)
                wb.save(os.path.join(self.GetDesktopPath(),self.mx_setting['out_excel_name']))
                print('解析成功，文件保存在桌面 名称为%s'%self.mx_setting['out_excel_name'])
            except Exception as e:
                print(e)
        else:
            print('no files')


    def write_to_excel_tyml():
        print('push btn')
        self.fileList=self.treeWidget.link
        if self.fileList!=[]:
            try:
                wb = openpyxl.workbook('test.xlsx')
                sheetnames = wb.get_sheet_names()
                sheet = wb.get_sheet_by_name(sheetnames[0])
                self.write_data(sheet)
                wb.save(os.path.join(self.GetDesktopPath(),self.mx_setting['out_excel_name']))
                self.msg1('解析成功，文件保存在桌面 名称为%s'%self.mx_setting['out_excel_name'])
                self.treeWidget.clear()
                self.treeWidget.link=[]
            except Exception as e:
                print(e)
        else:
            print('no files')


    def write_data(self,sheet,type=0):
        index=self.mx_setting['start_row']
        if type and type=='mx':
            start_col_1=self.mx_setting['mx_start_col_1']
            start_col_2=self.mx_setting['mx_start_col_2']
        else:
            start_col_1 = self.mx_setting['mx_start_col_1']
            start_col_2 = self.mx_setting['mx_start_col_2']
        for i in self.fileList:
            #写入文件
            sheet['%s%s'%(start_col_1,index)]=i['code']
            sheet['%s%s'%(start_col_2,index)] = i['name']
            index += 1#下一行