python - 无法使用函数获得正确的结果，包括 Python 上的另一个 excel 作家乐趣

Question

当我使用函数将数据写入 excel 时，无法获得正确的结果。

代码和结果如下：

正确版本：

def write_excel_format_test(value,writer,sheet_name,row_start,column_start):
    workbook = writer.book
    writer.sheets[sheet_name] = worksheet
    worksheet.write_row(row_start,column_start,value)

writer = pd.ExcelWriter('test.xlsx',engine = 'xlsxwriter')
workbook = writer.book
worksheet = workbook.add_worksheet('summary')
writer.sheets['summary'] = worksheet
worksheet.hide_gridlines(2)
worksheet.set_column("B:AE", 12)
row = 1
for i in range(0,10):
write_excel_format_test([i],writer,'summary',row+i,2)
worksheet.write(row+10,2,'success',format_title)
writer.save()

错误版本：

def fun_name():
    writer = pd.ExcelWriter('test1.xlsx',engine = 'xlsxwriter')
    workbook = writer.book
    worksheet = workbook.add_worksheet('summary')
    writer.sheets['summary'] = worksheet
    worksheet.hide_gridlines(2)
    worksheet.set_column("B:AE", 12)
    row = 1
    for i in range(0,10):
        write_excel_format_test([i],writer,'summary',row+i,2)
    worksheet.write(row+10,2,'success',format_title)
    writer.save()

fun_name()

正确的输出：

输出错误：

标签： pythonexcel