import pandas as pd
import openpyxl
filename="Tests.xlsx"
def createWorkBook():
wrkbk = openpyxl.Workbook()
ws = wrkbk.active
Sheets=["Rostered Patient","Non-Rostered Patient","Email","Error Handling"]
for sheet in Sheets:
if not sheet in wrkbk.sheetnames:
print("Created sheet: "+ sheet)
wrkbk.create_sheet(sheet)
wrkbk.save(filename)
def main():
Columns=[[""],["ID","Testing Procedure:","Pass/Fail","Issue#","Date"],[""],[""],[""]]
createWorkBook()
xl_writer = pd.ExcelWriter(filename, engine='openpyxl')
df = pd.DataFrame([["1","2","3","4","5",'6','7','8']],columns = Columns[1])
df.to_excel(xl_writer, 'Rostered Patient', index=False, startcol=1, startrow=1)
if __name__ == "__main__":
main()
我只是想将数据框附加到 Excel 文件的“名册患者”选项卡中。我想在每次运行代码时附加标题和 8 个 id。我的问题是使用 df_to_excel 与 startrow 和 startcol 一起运行它。