Skip to main content
 首页 » 编程设计

python之如何将 merge_range 和 write_formula 与 xlsxwriter python 结合起来

2024年10月25日14飞鱼

这是我正在尝试的代码。但它不起作用。

import xlsxwriter 
.... 
sheet.merge_range.write_formula('F16:H16', """IF('Original data'!B4<>"",'Original data'!B4,"")""", center) 

有没有别的代码可以把两者合二为一呢?我已经在做一些研究,但没有得到任何结果。提前致谢

请您参考如下方法:

来自 merge_range() 上的文档:

The merge_range() method writes its data argument using write(). Therefore it will handle numbers, strings and formulas as usual. If this doesn’t handle your data correctly then you can overwrite the first cell with a call to one of the other write_*() methods using the same Format as in the merged cells. See Example: Merging Cells with a Rich String.

这是一个基于您的示例的小示例:

import xlsxwriter 
 
workbook = xlsxwriter.Workbook('example.xlsx') 
worksheet1 = workbook.add_worksheet() 
worksheet2 = workbook.add_worksheet('Original data') 
 
center = workbook.add_format({'align': 'center', 'fg_color': 'yellow'}) 
 
 
worksheet1.merge_range('F16:H16', 
                       """=IF('Original data'!B4<>"",'Original data'!B4,"")""", 
                       center) 
 
worksheet2.write('B4', 'Hello') 
 
workbook.close() 

输出: