在原有excel写入数据

# 在原有excel写入数据
# 当前目录：
from openpyxl import load_workbook
wb = load_workbook("pyExcelTest.xlsx")#生成一个已存在的wookbook对象
wb1 = wb.active#激活sheet
wb1.cell(3,3,'pass')#往sheet中的第三行第三列写入‘pass’的数据
wb.save("pyExcelTest.xlsx")#保存
# 或
# 如果是有路径的：
from openpyxl import load_workbook
wb = load_workbook("C:\\Users\\18210\\Downloads\\pyExcelTest.xlsx")#生成一个已存在的wookbook对象
wb1 = wb.active#激活sheet
wb1.cell(3,3,'pass')#往sheet中的第三行第三列写入‘pass’的数据
wb.save("C:\\Users\\18210\\Downloads\\pyExcelTest.xlsx")#保存

import numpy as np
import pandas as pd

result=np.zeros(( 4,2 ))
# transform a to pandas DataFrame
result_pd = pd.DataFrame(result, columns=['dt', 'hang', 'RSN', 'PGA'])
# create writer to write an excel file------------------------------------------------------------
writer = pd.ExcelWriter('result.xlsx')
# write in ro file, 'sheet1' is the page title, float_format is the accuracy of data
result_pd.to_excel(writer, 'sheet1', float_format='%.4f')
# save file
writer.save()
# close writer
writer.close()