如何用python操作excel

lcy123456

import pandas as pd
import openpyxl
data = pd.read_excel("data.xlsx")
print(data)
data = {
'Name': ['Alice', 'Bob', 'Charlie'],
'Age': [25, 30, 35],
'City': ['New York', 'London', 'Paris']
}
df = pd.DataFrame(data)
df.to_excel("output.xlsx", index=False)
wb = openpyxl.load_workbook("data.xlsx")
sheet = wb["Sheet1"]
sheet["A1"] = "Updated Value"
new_sheet = wb.create_sheet("Sheet2")
wb.save("data_modified.xlsx")