Odoo - Attach Excel in the Email Template

This Odoo technical development blog is my way to contribute back to the Odoo Community, for all the selfless and great sharing by the community members.

If you want to send the excel as an attachment in the email template, use the 'render_xlsx' method (similar to render_pdf) to create the excel. See the following example.

@api.multi

def action_send_booking_confirmation_si(self):

self.ensure_one()

ir_model_data = self.env['ir.model.data']

try:

template_id = \

ir_model_data.get_object_reference('sci_goexcel_freight', 'email_template_edi_booking_confirmation')[1]

except ValueError:

template_id = False

try:

compose_form_id = ir_model_data.get_object_reference('mail', 'email_compose_message_wizard_form')[1]

except ValueError:

compose_form_id = False

excel_template_id = self.env.ref('sci_goexcel_freight.action_si_report_xlsx').render_xlsx(self.ids,[])

data_record = base64.b64encode(excel_template_id[0])

file_name = 'SI ' + self.booking_no + '.xlsx'

ir_values = {

'name': "Shipping Instruction",

'type': 'binary',

'datas': data_record,

'datas_fname': file_name,

'store_fname': 'Shipping Instruction',

'mimetype': 'application/xlsx',

}

excel_attachment = self.env['ir.attachment'].create(ir_values)

template = self.env['mail.template'].browse(template_id)

template.attachment_ids = False

template.attachment_ids = [(4, excel_attachment.id)]

ctx = {

'default_model': 'freight.booking',

'default_res_id': self.ids[0],

'default_use_template': bool(template_id),

'default_template_id': template_id,

'default_composition_mode': 'comment',

'mark_so_as_sent': True,

'custom_layout': "mail.mail_notification_light",

# 'proforma': self.env.context.get('proforma', False),

'force_email': True

}

base_url = self.env['ir.config_parameter'].sudo().get_param('web.base.url')

ctx['action_url'] = "{}/web?db={}".format(base_url, self.env.cr.dbname)

return {

'type': 'ir.actions.act_window',

'view_type': 'form',

'view_mode': 'form',

'res_model': 'mail.compose.message',

'views': [(compose_form_id, 'form')],

'view_id': compose_form_id,

'target': 'new',

'context': ctx,

}