Export [Bill of Materials] to Excel

Export [Bill of Materials] to Excel

This section explains how to export a bill of materials (BOM) created in CAXA Draft to Excel file.

Procedure:

[1] Open a new Excel file.

[2] Save the file in Excel Workbook format (e.g., on your desktop).

[3] In CAXA Draft, select [Database] in the [Paper] tab.

[4] In the displayed window, check [Export Data].

[5] Click the [...] button in the [Database operation] dialog.


[6] Select the Excel file you saved earlier and click [Open].

[7] In the [Database List Name:] field, enter a new sheet name for Excel.

Warning
You cannot specify a sheet name that already exists. Please enter a new one.

[8] Click [OK].
Info
The cell names defined by the BOM style will appear in the first row of the Excel sheet.
Notes
If exporting as an Excel Workbook (*.xlsx) fails, try saving and exporting using the older format: Excel 97–2003 (*.xls).

Please refer to the video below.

CA-028

    • Related Articles

    • Change Default Material Settings

      This section explains how to change the material information in the initial settings. Since the default material information cannot be modified directly, you need to duplicate the default settings, then modify and use the duplicated version. ...

    • Register Material Information in the Catalog

      This section explains how to register [Material] information in a catalog. The [Fill Eyedropper] function allows not only color, but also material information to be extracted and registered to the catalog. Before extracting information from a part, ...

    • Reflect Configuration in CAXA Draft

      You can utilize "Configurations" to suppress 3D components and save their positional information, allowing you to project configuration-specific drawings into CAXA Draft. The bill of materials (BOM) also supports display configurations, enabling you ...

    • Open data created in a newer version than the IRONCAD you are using

      Data created and saved in the new version cannot be opened in the old version. See also:Beware of Upgrades - IRONCAD User's Guide Again,IRONCAD 3D data cannot be stored in older versions of IRONCAD. If you want to open data created with a new version ...

    • Share your iVault settings with other users

      Explain how to individually list iVault files and BOM output settings, and share (change) with other members in the same settings. The settings you can share are as follows: Procedures ※It is retrieved on the original PC and pasted (override) to the ...