CAD and Excel-based batch process flow card generation method

The invention discloses a CAD and Excel-based batch process flow card generation method, which can be used for quickly importing part attributes of process flow cards from quotation files without repeated input by establishing a standard process flow card detail table file. In this file, processes of various conditions are established in a form established for each typical part; a unique typical process number is established for each condition; a VBA program is used, so the required process can be quickly queried; when another blank template file directly calls the former information to the latter or quickly modifies after calling, the weight of the plane cutting part can be quickly calculated, data in a process file can be quickly processed to generate data required by ERP, the original manual process compiling work of several hours can be completed in several minutes, and the process compiling efficiency and standardization are improved. 本发明公开了一种基于CAD和Excel的批量工艺流转卡生成方法，本发明可实现工艺流转卡的零件属性快速从报价文件中导入，无需重复输入，通过建立