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

Question

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

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

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

Answer 1

来自 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()

输出: