如何使用xlsxwriter for python将数据导出到xlsx

Question

我无法将数据写入excel文件。运行此代码不会将文件写入预期的文件夹。在

import xlsxwriter

workbook = xlsxwriter.Workbook('C:\\Users\\hburk\\Desktop\\Python\\sqloutput.xlsx')
east = workbook.add_worksheet()



eastdata = (
        ['apples', 4.0],
        ['bananas', 5.0],
        )

    row = 1
    col = 0
    for pointname, price in eastdata:
        east.write_string(row, col, pointname)
        east.write(row, col+1, price)
        row += 1

workbook.close()

编辑：改变了错误东。关（）-我试图从原始代码中简化这一点，并把一些东西弄糟了。代码仍然不能像这里写的那样工作。在

Answer 1

请不要忘记关闭Workbook：

workbook.close()

Answer 2

The code still doesn't work as written here.

如果你修复了压痕，它应该可以工作。我查过这个：

import xlsxwriter

workbook = xlsxwriter.Workbook('sqloutput.xlsx')
east = workbook.add_worksheet()


eastdata = (
    ['apples', 4.0],
    ['bananas', 5.0],
)

row = 1
col = 0
for pointname, price in eastdata:
    east.write_string(row, col, pointname)
    east.write(row, col+1, price)
    row += 1

workbook.close()

得到了这个：