如何用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()

输出：

{1美元^