Translate data report xlsx Odoo v11.0

Question

I am using module "Base report xlsx" and xlsxwriter to write a report xlsx. But i have a problem about translate data. I alr use _() method and translate it in my language (vi.po -vietnamese) like:
title_line_format = workbook.add_format({'bold': True, 'font_size': 20, 'align': 'center'})
data = _("Procurement List Report")
sheet.merge_range('A1:N3', data, title_line_format)
But when i export, my file still be written by english . Am i wrong? Can anyone explain why it didin't work?
Thanks and Re

Nomadic Coding · Accepted Answer

It seems the lang context is lost when using report_xlsx
You can force the language on the report.py

e.g.
def  generate_xlsx_report ( self , workbook , data ,  products ):
#force language
self = self .with_context( lang = self .env.user.lang)

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Translations for the top menu URL's translation	0 jouluk. 24	1443
downloading the po file translation	2 helmik. 24	2961
Language translation through .po file translation	4 marrask. 23	3405
Unable to change Javascript translation translation	1 elok. 22	3706
Change default location in update quantity on hand window Ratkaistu odoov11	2 heinäk. 22	9187

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!