Excel集成如何使用python Openpyx在特定单元格范围内附加数据帧

2024-10-04 05:34:05 发布

您现在位置:Python中文网/ 问答频道 /正文

我正试图使用Python的Openpyxl模块将pandas数据帧附加到xlsm文件中。
问题是我在Excel文件上写了,但是在第一列上,但是我想写在Excel的空白空间上。 谁能指出我的语法哪里不正确吗?
下面是该表的图像和我的python代码

excel table

import pandas as pd
from pandas import read_excel, read_csv
import openpyxl as px
from openpyxl import Workbook, load_workbook, cell
import numpy as np
from openpyxl.compat import range
from openpyxl.utils.dataframe import dataframe_to_rows


a = load_workbook(r"C:\Users\45050393\Documents\libro_vacio.xlsm", keep_vba = True)
df = pd.DataFrame({1 : [23, 34, 56, 78, 89, 12, 48]})
print(df)
ws = a.active
hoja_a_marcar = a.get_sheet_by_name("Sheet1")
startcol = ws["H2":"H8"]
hoja_a_marcar.cell(row = 3, column = 4).value 

for r in dataframe_to_rows(df, index = False, header = False):
    for rows in startcol:
          ws.append(r)

print("HECHO")
a.save(filename= r"C:\Users\45050393\Documents\libro_vacio.xlsm")

Tags: 文件fromimportdataframepandasdfreadws