格式化allegro物料清单为嘉立创格式

#!/usr/bin/python3
#coding:utf-8
import re
import pandas as pd
import openpyxl
from openpyxl import Workbook

#物料种类
ENUM = 500

#读取原始表格
workbook=openpyxl.load_workbook("input.xlsx")
worksheet=workbook.worksheets[0]

#实例化
wb=Workbook()
#激活worksheet
ws=wb.active
ws.title = "AUTO BOM"
# A,B,C列列宽
ws.column_dimensions['A'].width = 30
ws.column_dimensions['B'].width = 100
ws.column_dimensions['C'].width = 30


ws['A1'].value = 'Comment'
ws['B1'].value = 'Designator'
ws['C1'].value = 'Footprint'

for i in range(2,ENUM):
    
    ws.cell(i,1,str(worksheet.cell(i, 3).value).replace(';',',').replace('None',''))
    ws.cell(i,2,str(worksheet.cell(i, 7).value).replace(';',',').replace('None',''))
    ws.cell(i,3,str(worksheet.cell(i, 1).value).replace(';',',').replace('None',''))

wb.save(filename="output.xlsx")

最终效果: 读取input.xlsx,格式化后输出output.xlsx