如何在不使用向导的情况下从窗体视图打印excel文件

2022-09-28 21:40:46 发布

您现在位置:Python中文网/ 问答频道 /正文

我需要从窗体视图打印excel文件而不使用向导问题是,当按下generate_bt键时,同一个窗体视图看起来像一个框。你知道吗

Code

# -*- coding: utf-8 -*-

from odoo import models, fields, api
from odoo.tools.translate import _
from odoo.exceptions import UserError, AccessError
from datetime import datetime, timedelta
import dateutil.parser
import base64
import xlwt
from cStringIO import StringIO
from pprint import pprint
import logging
from openerp import tools
_logger = logging.getLogger(__name__)


class SerialNumberXls(models.Model):
    _inherit = 'stock.picking'
    excel_file = fields.Binary(string='Download Report Excel',readonly="1")
    file_name = fields.Char(string='Excel File',readonly="1")

    def generate_bt(self):
        workbook= xlwt.Workbook(encoding="UTF-8")
        filename='SerialNumbers.xls'
        sheet= workbook.add_sheet('Serial Number',cell_overwrite_ok=True)
        style = xlwt.easyxf('font:name Arial,height 200;')
        style2 = xlwt.easyxf('font:name Arial,height 200,bold True;align: horiz center, vert center;')
        style_filter = xlwt.easyxf('font:name Arial; align: horiz center, vert center;')
        style_normal_left = xlwt.easyxf('font:name Arial; align: horiz left, vert center;')
        style_normal_right = xlwt.easyxf('font:name Arial; align: horiz right, vert center;')
        row = 0
        col = 0

        for line in self.move_lines:
            print "EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE"
            for product in line.quant_ids:
                print "SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS"
                col = 0
                product_id = product.product_id and product.product_id.name or False
                sl_no = product.lot_id and product.lot_id.name or False
                sheet.write(row,col,product_id,style)
                col = col + 1
                sheet.write(row,col,sl_no,style)
                row = row + 1

        fp = StringIO()
        workbook.save(fp)
        excel_file = base64.encodestring(fp.getvalue())
        self.excel_file = excel_file
        self.file_name =filename
        fp.close()  

        return {
          'view_type': 'form',
          "view_mode": 'form',
          'res_model': 'stock.picking',
          'res_id': self.id,
          'type': 'ir.actions.act_window',
          }

Tags: namefromimportselfidstylecolproductexcelfilecenterfontxlwteasyxfarial