山东智趣岛论坛

标题: 如何用python操作excel [打印本页]

作者: lcy123456 时间: 2023-10-22 16:15
标题: 如何用python操作excel
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")

欢迎光临山东智趣岛论坛 (https://abc.sdzqd.com/)