跳至内容
菜单
此问题已终结
1 回复
7596 查看

i've created an xls report in odoo 13 and all of its styles are working well in ubuntu excel, but all of the styles are not working in windows excel sheet.

the code is given below;

cell_format = workbook.add_format({'align': 'center','font_size': '12px','bold': True,'border': 2})
head = workbook.add_format({'align': 'center', 'bold': True,'font_size':'16px','border': 2})
col_head = workbook.add_format({'align': 'center', 'font_size': '11px', 'bold': True,'border': 2})
col_bot = workbook.add_format({'font_size': '11px', 'bold': True})
txt = workbook.add_format({'align': 'center', 'font_size': '10px','border': 2})

sheet.merge_range('B2:K3', 'METAL INDUSTRIES', head)

monthinteger = int(data['month'])
month = date(int(data['year']), monthinteger, 1).strftime('%B')

sheet.merge_range('E4:H4', "SALARY"+ "-" + month + "-" + data['year'],cell_format)

sheet.write('A6', 'S.No:', col_head)
sheet.write('B6', 'EMPLOYEE NAME', col_head)

形象
丢弃

Hi 

Did you please find solution to this issue I have the same?

最佳答案

Hi Fazil 

Try this 

cell_format = workbook.add_format({'align': 'center','font_size': 12,'bold': True,'border': 2})

head = workbook.add_format({'align': 'center', 'bold': True,'font_size':16,'border': 2})

col_head = workbook.add_format({'align': 'center', 'font_size': 11, 'bold': True,'border': 2})

col_bot = workbook.add_format({'font_size': 11, 'bold': True})

txt = workbook.add_format({'align': 'center', 'font_size': 10,'border': 2})


Regards 


形象
丢弃
相关帖文 回复 查看 活动
2
3月 15
9812
2
6月 25
2669
4
8月 24
77209
1
4月 22
1526
0
1月 22
2014