按钮 excel ，python端导出

True

主要用插件 XlsxWriter(https://xlsxwriter.readthedocs.io/index.html)

好处

1.合并单元格，颜色，都比较方便，据说比xlwt 屌

按钮触发

   @api.multi
    def export_train_run_notice_excel(self):
        return {
            'type': 'ir.actions.act_url',
            'target': 'self',
            'url': '/construction_dispatch/train_run_notice_excel',
        }

xxxxxxxxxx
 
   @api.multi
    def export_train_run_notice_excel(self):
        return {
            'type': 'ir.actions.act_url',
            'target': 'self',
            'url': '/construction_dispatch/train_run_notice_excel',
        }
​
已复制

通过url 去触发controller

controller 端，通过ByteIO，写内存，然后respone返回

    from io import BytesIO

    @http.route('/construction_dispatch/train_run_notice_excel', type='http', auth="user")
    def export_train_run_notice_excel(self, **kwargs):
        buffer_xlsx = BytesIO()
        workbook = xlsxwriter.Workbook(buffer_xlsx)
        worksheet = workbook.add_worksheet()
        
        。。。
        
        workbook.close()
        buffer_xlsx.seek(0)
        response = request.make_response(buffer_xlsx.read(),
                                         headers=[('Content-Type', 'application/vnd.ms-excel'),
                                                  ('Content-Disposition', 'attachment; filename={}'.format(
                                                      "行车通告.xlsx".encode().decode('latin-1')
                                                  ))],
                                         cookies={'fileToken': '123'}) #token没啥用样
         return response

xxxxxxxxxx
 
    from io import BytesIO
​
    @http.route('/construction_dispatch/train_run_notice_excel', type='http', auth="user")
    def export_train_run_notice_excel(self, **kwargs):
        buffer_xlsx = BytesIO()
        workbook = xlsxwriter.Workbook(buffer_xlsx)
        worksheet = workbook.add_worksheet()
        
        。。。
        
        workbook.close()
        buffer_xlsx.seek(0)
        response = request.make_response(buffer_xlsx.read(),
                                         headers=[('Content-Type', 'application/vnd.ms-excel'),
                                                  ('Content-Disposition', 'attachment; filename={}'.format(
                                                      "行车通告.xlsx".encode().decode('latin-1')
                                                  ))],
                                         cookies={'fileToken': '123'}) #token没啥用样
         return response
已复制

测试代码，xlsxwiter的

import xlsxwriter


def writeImport():
    # 1,048,576  limit row
    workbook = xlsxwriter.Workbook('hello.xlsx',  {'constant_memory': True})
    worksheet = workbook.add_worksheet()

    COLOR_MAP = {
        'yes': 'red',
        'no': '#50bf85',
        'no_electric_grand_line': '#159588',
        'repeatedly_electric': '#e36c09'
    }

    merge_format_title = workbook.add_format({  #可以设置color 给font设置颜色
        'font_size': '20',
        'bold':     True,
        'border':   1,
        'align':    'center',  # 水平居中
        'valign':   'vcenter',  # 垂直居中
    })
    format_title1 = workbook.add_format({
        'font_size': '16',
        'bold':     True,
        'border':   1,
        'align':    'center',  # 水平居中
        'valign':  'vcenter',  # 垂直居中
    })
    format_title2 = workbook.add_format({
        'font_size': '11',
        'bold':     True,
        'border':   1,
        'align':    'center',  # 水平居中
        'valign':  'vcenter',  # 垂直居中
    })
    format_row = workbook.add_format({
        'font_size': '10',
        'bold':     True,
        'border':   1,
        'align':    'center',  # 水平居中
        'valign':  'vcenter',  # 垂直居中
        'text_wrap': True
    })

    # 设置默认列宽度
    worksheet.set_column('A:A', 5)
    worksheet.set_column('B:B', 18)
    worksheet.set_column('C:C', 18)
    worksheet.set_column('D:D', 18)
    worksheet.set_column('E:E', 28)
    worksheet.set_column('F:F', 28)
    worksheet.set_column('G:G', 34)
    worksheet.set_column('H:H', 17)
    worksheet.set_column('I:I', 22)
    worksheet.set_column('J:J', 15)
    worksheet.set_column('K:K', 32)

    row_num = 0
    MAX_COL = 10

    def writeDateTitle(row_num, text):
        worksheet.merge_range(row_num, 0, row_num, MAX_COL,
                              '2018年11月22日（周三）', format_title1)
        worksheet.set_row(row_num, 25)

    def writePlanTypeRow(row_num, text):
        for i in range(MAX_COL+1):
            if i == 0:
                worksheet.write(row_num, i, text, format_title2)
            else:
                worksheet.write(row_num, i, '', format_row)

    def writePlanTitleRow(row_num, row_count):
        TITLES = ['项', '作业令号', '作业时间', '施工单位', '作业内容', '作业区域', '接触网供电安排',
                  '防护措施', '配合单位及内容', '施工负责人', '备注']
        for i in range(MAX_COL+1):
            worksheet.write(row_num, i, TITLES[i], format_title2)
        worksheet.autofilter('A4:K4')   #设置autofilter

    # 第一行
    worksheet.merge_range(row_num, 0, row_num, MAX_COL,
                          '施工及行车通告', merge_format_title)  #合并单元格
    row_num += 1
    worksheet.set_row(0, 40)

    writeDateTitle(row_num, '2018年11月22日（周三）')
    row_num += 1
    writePlanTypeRow(row_num, '周计划')
    row_num += 1

    rows = [
        ['1', '2', '3', '4', '5独立开发就算了会计法打死了解放路口的设计费两款手机发了多少解放路看时间分类看电视解放东路开始解放路口束带结发',
         '6', '7', '8', '9', '10', '11'],
        ['2', '2', '3', '4', '5独立开发就算了会计法打死了解放路口的设计费两款手机发了多少解放路看时间分类看电视解放东路开始解放路口束带结发',
         '6', '7', '8', '9', '10', '11'],
    ]

    writePlanTitleRow(row_num, len(rows))
    row_num += 1

    for row in rows:
        for i in range(MAX_COL+1):
            if i < len(row):
                worksheet.write(row_num, i, row[i], format_row)
            else:
                worksheet.write(row_num, i, '', format_row)
        row_num += 1

    #...loop
    writeDateTitle(row_num, '2018年11月22日（周三）')
    row_num += 1
    writePlanTypeRow(row_num, '周计划')
    row_num += 1

    rows = [
        ['1', '2', '3', '4', '5独立开发就算了会计法打死了解放路口的设计费两款手机发了多少解放路看时间分类看电视解放东路开始解放路口束带结发',
         '6', '7', '8', '9', '10', '11'],
        ['2', '2', '3', '4', '5独立开发就算了会计法打死了解放路口的设计费两款手机发了多少解放路看时间分类看电视解放东路开始解放路口束带结发',
         '6', '7', '8', '9', '10', '11'],
    ]

    writePlanTitleRow(row_num, len(rows))
    row_num += 1
    for row in rows:
        for i in range(MAX_COL+1):
            if i < len(row):
                worksheet.write(row_num, i, row[i], format_row)
            else:
                worksheet.write(row_num, i, '', format_row)
        row_num += 1

    workbook.close()


writeImport()

xxxxxxxxxx
 
import xlsxwriter
​
​
def writeImport():
    # 1,048,576  limit row
    workbook = xlsxwriter.Workbook('hello.xlsx',  {'constant_memory': True})
    worksheet = workbook.add_worksheet()
​
    COLOR_MAP = {
        'yes': 'red',
        'no': '#50bf85',
        'no_electric_grand_line': '#159588',
        'repeatedly_electric': '#e36c09'
    }
​
    merge_format_title = workbook.add_format({  #可以设置color 给font设置颜色
        'font_size': '20',
        'bold':     True,
        'border':   1,
        'align':    'center',  # 水平居中
        'valign':   'vcenter',  # 垂直居中
    })
    format_title1 = workbook.add_format({
        'font_size': '16',
        'bold':     True,
        'border':   1,
        'align':    'center',  # 水平居中
        'valign':  'vcenter',  # 垂直居中
    })
    format_title2 = workbook.add_format({
        'font_size': '11',
        'bold':     True,
        'border':   1,
        'align':    'center',  # 水平居中
        'valign':  'vcenter',  # 垂直居中
    })
    format_row = workbook.add_format({
        'font_size': '10',
        'bold':     True,
        'border':   1,
        'align':    'center',  # 水平居中
        'valign':  'vcenter',  # 垂直居中
        'text_wrap': True
    })
​
    # 设置默认列宽度
    worksheet.set_column('A:A', 5)
    worksheet.set_column('B:B', 18)
    worksheet.set_column('C:C', 18)
    worksheet.set_column('D:D', 18)
    worksheet.set_column('E:E', 28)
    worksheet.set_column('F:F', 28)
    worksheet.set_column('G:G', 34)
    worksheet.set_column('H:H', 17)
    worksheet.set_column('I:I', 22)
    worksheet.set_column('J:J', 15)
    worksheet.set_column('K:K', 32)
​
    row_num = 0
    MAX_COL = 10
​
    def writeDateTitle(row_num, text):
        worksheet.merge_range(row_num, 0, row_num, MAX_COL,
                              '2018年11月22日（周三）', format_title1)
        worksheet.set_row(row_num, 25)
​
    def writePlanTypeRow(row_num, text):
        for i in range(MAX_COL+1):
            if i == 0:
                worksheet.write(row_num, i, text, format_title2)
            else:
                worksheet.write(row_num, i, '', format_row)
​
    def writePlanTitleRow(row_num, row_count):
        TITLES = ['项', '作业令号', '作业时间', '施工单位', '作业内容', '作业区域', '接触网供电安排',
                  '防护措施', '配合单位及内容', '施工负责人', '备注']
        for i in range(MAX_COL+1):
            worksheet.write(row_num, i, TITLES[i], format_title2)
        worksheet.autofilter('A4:K4')   #设置autofilter
​
    # 第一行
    worksheet.merge_range(row_num, 0, row_num, MAX_COL,
                          '施工及行车通告', merge_format_title)  #合并单元格
    row_num += 1
    worksheet.set_row(0, 40)
​
    writeDateTitle(row_num, '2018年11月22日（周三）')
    row_num += 1
    writePlanTypeRow(row_num, '周计划')
    row_num += 1
​
    rows = [
        ['1', '2', '3', '4', '5独立开发就算了会计法打死了解放路口的设计费两款手机发了多少解放路看时间分类看电视解放东路开始解放路口束带结发',
         '6', '7', '8', '9', '10', '11'],
        ['2', '2', '3', '4', '5独立开发就算了会计法打死了解放路口的设计费两款手机发了多少解放路看时间分类看电视解放东路开始解放路口束带结发',
         '6', '7', '8', '9', '10', '11'],
    ]
​
    writePlanTitleRow(row_num, len(rows))
    row_num += 1
​
    for row in rows:
        for i in range(MAX_COL+1):
            if i < len(row):
                worksheet.write(row_num, i, row[i], format_row)
            else:
                worksheet.write(row_num, i, '', format_row)
        row_num += 1
​
    #...loop
    writeDateTitle(row_num, '2018年11月22日（周三）')
    row_num += 1
    writePlanTypeRow(row_num, '周计划')
    row_num += 1
​
    rows = [
        ['1', '2', '3', '4', '5独立开发就算了会计法打死了解放路口的设计费两款手机发了多少解放路看时间分类看电视解放东路开始解放路口束带结发',
         '6', '7', '8', '9', '10', '11'],
        ['2', '2', '3', '4', '5独立开发就算了会计法打死了解放路口的设计费两款手机发了多少解放路看时间分类看电视解放东路开始解放路口束带结发',
         '6', '7', '8', '9', '10', '11'],
    ]
​
    writePlanTitleRow(row_num, len(rows))
    row_num += 1
    for row in rows:
        for i in range(MAX_COL+1):
            if i < len(row):
                worksheet.write(row_num, i, row[i], format_row)
            else:
                worksheet.write(row_num, i, '', format_row)
        row_num += 1
​
    workbook.close()
​
​
writeImport()
​
已复制

in Funenc Odoo Team

# odoo汇总

搜索计算字段

True