Specifications
Converting CAD Data Using Excel
In a production environment, the same software package which generates the
Pick & Place machine programs can usually generate the CXF file for the AOI
automatically, but if you are doing a demo or just evaluating the machine you
may need to convert the CAD data to a CXF file manually.
The Excel software can be used to format text data into a CXF file. First
prepare the CAD data into columns of text. From the Excel menu select File |
Open. Excel's import wizard will start and guide you. Select Delimited, press
Next, and then select Space as delimited. Press Finish; you will see the data
append as Excel columns.
Manipulate the data into the correct format. There is a sample CXF file in
Appendix I on page 81. After completing the manipulation, save the file as
Space Delimited Text with a .CXF extension. When specifying the file name,
it is essential to enclose the file name in double quotation marks such as
"Board1023.cxf". This prevents Excel from appending an additional file
extension (.prn - e.g., Board1023.cxf.prn) to the file name.