- 1String/StringBuilder/ToString()底层代码解析（ JAVA / C# ）_tostring stringbulider
- 2【Linux】Linux基本指令1
- 3SAP GUI Scripting案例2:创建用户 Excel导入数据_createobject("sapgui.scriptingctrl.1")
- 4window安全中心关闭防火墙后仍然会将xx文件删除的解决办法_win11 defender关闭后仍然会删除威胁
- 5mac 下为python3.7 安装pyqt5_macosx python3.7 安装pyqt5
- 6HashMap、ArrayMap、SparseArray分析比较_3、 hashmap 工作原理是什么?与 sparsearray 、 arraymap 有什么差异?
- 7AWVS安装与使用_awvs下载
- 8学Python对财务人员有什么用？_python对会计的帮助
- 9git使用及github
- 10人脸识别的表情识别子任务：表情识别和情感分析
AD应用自定义BOM料单模板_ad bom模板
赞
踩
1.新建一个Excel，并在自己设计对应的区域填入 字段=字段名字
2.字段的第一类是Field，用于映射项目信息，BOM表头以及文档和项目参数。
可用的系统级字段名字有：
| 字段 | 描述 |
|---|---|
| Currency | The currency that has been chosen in the Supplier Options region of the Report Manager dialog. |
| DataSourceFileName | The filename of the source used for the BOM data. |
| DataSourceFullPath | The full path + filename of the source used for the BOM data. |
| GeneratorDescription | For a BOM, this field displays Bill of Materials. |
| GeneratorName | Name of the generator - BOM when output is generated by the Report Manager. |
| OutputName | Title of the BOM, as displayed in the Report Manager (excluding the text “For BOM Document []”). |
| OutputType | For a BOM, this field displays BOM_PartType. |
| PCBDataSourceFileName | The filename of the PCB data source. |
| ProductionQuantity | Production quantity defined in the Report Manager dialog. |
| ProjectFileName | Name of the PrjPcb file (including file extension). |
| ProjectFullPath | Full path + the project filename. |
| ReportDate | Date on which the report was created. |
| ReportDateTime | Date and time at which the report was created. |
| ReportTime | Time at which the report was created. |
| TotalQuantity | Sum of the values in the BOM Items Quantity column. |
| Title | Title displayed at the top of the BOM Reports dialog. |
| VariantName | Name of the variant, as defined in the Variant Management dialog. |
| VersionControl_RevNumber | Current revision of the BomDoc. |
| VersionControl_ProjFolderRevNumber | Current revision of the project (incremented when a Commit Whole Project is performed). |
| <UserProjectParameter_n> | Displays the value assigned to the user-defined UserProjectParameter-n. |
可用的文档和项目字段名字：
Address1，Address2，Address3，Address4， ApprovedBy，Author，CheckedBy，CompanyName， ConfigurationParameters，CurrentDate， CurrentTime，Date，DocumentFullPathAndName，Docu
mentName，DocumentNumber，DrawnBy，Engineer，ImagePath，Index，ModifiedDate，Organiz
ation，Revision，Rule，SheetNumber，SheetTotal， Time
字段的第二类是Column，用于映射BOM的条目信息。
component参数的字段名字有:
Comment，ComponentKind，Description，Designator，DesignItemId，Footprint，LibRef，Logical
Designator，PartType，PhysicalPath，Quantity，UniqueIdName，UniqueIdPath， <UserParameter_n>
PCB的component参数的字段名字有:
Center-X(Mil)，Center-Y(Mil)，Center-X(mm)，Center-Y(mm)，Pad-X(Mil)，Pad-Y(Mil)，Pad-X(mm)，
Pad-Y(mm)，Ref-X(Mil)，Ref-Y(Mil)，Ref-X(mm)，Ref-Y(mm)，Layer，Rotation
供应商数据的字段名字有:
Manufacturer x，Manufacturer，Part Number x，Supplier x，Supplier Currency x，Supplier Order Qty x，
Supplier Part Number x，Supplier Stock x，Supplier Subtotal x，Supplier Unit Price x
以及用户自定义的字段名
下面给出两个实例图片:
第一张图为模板的字段=字段名字设置:
第二张图是导入BOM之后的效果:
Excel填写完成之后还得将此Excel粘贴到AD软件安装目录->Templates目录下，之后进入AD元件BOM料单管理之后，点开template列表即可看到自己的BOM模板，选中进行导出就完事了！
最后附上AD官网的连接:
AD官网BOM料单模板连接
