从转角,摆角,长度---＞x,y,z三维坐标

import math
from openpyxl import load_workbook, Workbook

# 打开原始Excel文件
wb = load_workbook('result040810-116个点.xlsx')
ws = wb.active

# 创建新的Excel文件
wb_new = Workbook()
ws_new = wb_new.active

# 添加表头
ws_new.cell(row=1, column=1).value = 'x'
ws_new.cell(row=1, column=2).value = 'y'
ws_new.cell(row=1, column=3).value = 'z'

# 遍历每行数据并转换坐标
for row in range(2, ws.max_row+1):  # 从第2行开始读取数据
    b = ws.cell(row=row, column=1).value
    c = ws.cell(row=row, column=2).value
    d = ws.cell(row=row, column=3).value
    x = math.sin(c * math.pi / 180) * d * -1 * math.cos(b * math.pi / 180)
    y = math.sin(c * math.pi / 180) * d * -1 * math.sin(b * math.pi / 180)
    z = d * math.cos(c * math.pi / 180)
    ws_new.cell(row=row, column=1).value = round(x, 2)  # 将转换后的数据写入新的Excel文件
    ws_new.cell(row=row, column=2).value = round(y, 2)
    ws_new.cell(row=row, column=3).value = round(z, 2)

    # 添加数字格式
    for col in range(1, 4):
        ws_new.cell(row=row, column=col).number_format = '0.00'

# 保存新的Excel文件
wb_new.save('result040810-116个点-1.xlsx')

转换前,转换后