我正试图使用Python的Openpyxl模块将pandas数据帧附加到xlsm文件中。
问题是我在Excel文件上写了,但是在第一列上,但是我想写在Excel的空白空间上。
谁能指出我的语法哪里不正确吗?
下面是该表的图像和我的python代码
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")
目前没有回答
相关问题 更多 >
编程相关推荐