实验数据处理源文件

from openpyxl import load_workbook

# 定义参数
quality = 5.097
velocity = 2.657
g = 9.7

# 获取文件位置
print("请输入待操作excel文件地址")
print("注意：不使用双引号!!!!!!")
print("否则将报错！")
path = input()

# 创建列表实例
wb = load_workbook(path)
ws1 = wb.active
ws1.title = "F-t"
ws2 = wb.create_sheet("F-x", 1)
ws3 = wb.create_sheet("E-t", 2)

# 开始操作单元格
for x in range(1, 202):
    # 获取时间，载荷，一次积分，二次积分的数值
    Time = ws1.cell(x, 1).value
    force = ws1.cell(x, 2).value
    first = ws1.cell(x, 3).value
    second = ws1.cell(x, 4).value
    # 运用公式计算位移，瞬时速度，能量
    displacement = velocity*Time+0.5*g*Time*Time-second/quality
    velocity_plus = velocity+g*Time-first/quality
    energy = 0.5*quality*velocity*velocity-0.5*quality*velocity_plus*velocity_plus+quality*g*displacement
    # 将得到的数据存储新建的两个工作表
    ws2.cell(x, 1, value=displacement)
    ws2.cell(x, 2, value=force)
    ws3.cell(x, 1, value=Time)
    ws3.cell(x, 2, value=energy)
wb.save(path)
print("操作完成，已保存在原路径")