Skip to Content
Menu
This question has been flagged
1 Reply
7662 Views

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)

Avatar
Discard

Hi 

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

Best Answer

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 


Avatar
Discard
Related Posts Replies Views Activity
2
Mar 15
9872
2
Jun 25
2753
4
Aug 24
77551
1
Apr 22
1597
0
Jan 22
2067