更新: 写了个python脚本用于格式转换.
import csv
csvfile = open('pcp_rep.rpt')
reader = csv.reader(csvfile)
csvfile2 = open('pcp_rep_jlc.csv', 'w', newline='\n')
writer = csv.writer(csvfile2, dialect='excel')
for line in reader:
if len(line) != 1:
break # 跳过前四行
# 按JLC的格式修改表头
line = ['Designator', 'Comment', 'Footprint', 'Mid X', 'Mid Y', 'Rotation', 'Layer']
print(line)
writer.writerow(line)
# 查找替换表, 请按需自行修改
my_footprints = ['CAPC2012', 'CAPC1608', 'RESC2012', 'RESC1608']
jlc_footprints = ['C0805', 'C0603', 'R0805', 'R0603']
for line in reader:
del line[1], line[2] # 删除不需要的两列
if line[6] == 'NO':
line[6] = 'T'
elif line[6] == 'YES':
line[6] = 'B'
if line[2] in my_footprints:
line[2] = jlc_footprints[my_footprints.index(line[2])]
print(line)
writer.writerow(line)
csvfile.close()
csvfile2.close()
Stavros (AUV45 6BDNT) 在 ta 的帖子中提到:
用于JLC的SMT下单
截图就不用贴了吧?
1. Allegro 菜单点 Tools, Reports
……