pandas转openpyxl
from openpyxl.utils.dataframe import dataframe_to_rows
wb = Workbook()
ws = wb.active
for row in dataframe_to_rows(df, index=False, header=True):
ws.append(row)
openpyxl转pandas
values = sheet.values
df = pd.DataFrame(values)
pandas转openpyxl
from openpyxl.utils.dataframe import dataframe_to_rows
wb = Workbook()
ws = wb.active
for row in dataframe_to_rows(df, index=False, header=True):
ws.append(row)
openpyxl转pandas
values = sheet.values
df = pd.DataFrame(values)