利用python實現Excel合併單元格
操作代碼如下:# encoding=gbk
import xlsxwriter
# 自定義單元格格式
def set_merge_style(workbook, tag):
number_format, font_color, align = '', '', 'center'
if tag == 'head1':
bold, font_size, border = True, 14, 1
fg_color = '#4F81BD'
font_color = 'white'
else:
bold, font_size, border = True, 12, 1
fg_color = '#FFFFFF'
font_color = 'red'
number_format = Ɔ.00%'
cell_format = _format({
'bold': bold
'font_size': font_size
'border': border
'align': align
'valign': 'vcenter', # 垂直居中
'fg_color': fg_color, # 顏色填充
'num_format': number_format
'font_color': font_color
'font_name': '宋體'
})
return cell_format
workbook = book(')
worksheet = _worksheet('表格1')
# 合併A列-N列,第一個參數是位置,第二個參數是內容,第三個參數是自定義格式
e_range('A1:N2', 'xx模型xx清單',set_merge_style(workbook, tag='head1'))
e_range('A3:N3', '次級標題1',set_merge_style(workbook, tag='head2'))
#設置行高,set_tow(行號,對應行高)