用Python将数据保存到excel文件中

Question

我编写了一个python代码，以获得如下代码段的字符串输出。你知道吗

a = "First "
b = "Second"
c = a+b

每次运行时，我都需要在excel文件中保存c的值程序。怎么做我能做到吗？你知道吗

Answer 1

from openpyxl import Workbook
a = "First "
b = "Second"
c = a+b
file_path= "temp.xlsx"

wb = Workbook()
ws = wb.active
ws.append(c)
wb.save(file_path)

Answer 2

首先将excel文件命名为测试.xlsx 然后使用以下代码加载文件并写入：

from openpyxl import load_workbook

filename= 'test.xlsx'
wb = load_workbook(filename)
file = wb.active

file.append(["data"])

wb.save(filename=filename)