Import and Export Macro

Introduction of drawing table

Drawing table is an important feature in engineering drawings. It is one of the means of communicating required information between manufacturing partners or confined to a single manufacturing plant. There are different tables in engineering drawing for example BOM Table, Hole Dimension Table, Design table etc. . .

Situation – Business Need

Many Manufacturing sectors have different norms of tables in their work-space and most users want some additional options in table than the conventional one. So it consumes so much time to generate drawing tables following those conventions. Since there is a human intervention in this monotonous work there are more chances of making misentries or missing some data in table. These kind of mistake can lead to a huge impact on the end product. So there is a need to automate the process of creating tables which should be enhanced one than manually created tables.

This business situation requires:

  1. Minimize Errors – Reduce Human Errors.
  2. Enhanced Table – Make attribute links to each text range of the table.
  3. Table Style – Set font properties to drawing table as of excel file.
  4. Time Factor – Reducing the time in generating or updating the table by automation

Challenges Faced

There were a range of challenges faced during the course of the project. Few of them are listed below:

  1. Implementing for macro to make it consume less time in Drawing table operation was challenging.
  2. Validation check for some data is not available directly in CAD API’s.
  3. To make generic macro which can reach basic needs for all table types and for all users.

Our Solution

After carefully consideration of requirements and analysis of the API provided by the CAD system, we have come up with two macros.
They are:

  1. IMPORT TABLE
  2. EXPORT TABLE

IMPORT TABLE:

Macro to generate table from Excel data.

Some of the features we included in import table command are:

  • Importing table data from Excel file and creating the table at mouse click.
  • Selecting type of table to be generated.(BOM Table, Hole Dimension Table, …)
  • Updating of table by adding, removing or changing position of Table columns.
  • Change position and Anchor point of Table.
  • Change the table header row position (at Top or at Bottom).
  • Validate the imported table data.

Screen Shot 2015-09-09 at 10.29.59 PM

EXPORT TABLE:

Macro to extract table data and store in excel file.

Some of the features we included in export table command are:

  • To select any table and copy the data to browse excel file.
  • Replace an existing file data with new table data.

Screen Shot 2015-09-09 at 10.29.59 PM

Result:

  • Flexibility for user to handle Drawing tables with ease.
  • Attribute links to each text range in table gives updation of data according to changes in sheet. Hence makes tables more enhanced.
  • Validating of table data and reflecting wrong data to users.
  • Since macro can handle variety of tables. Hence increases productivity of users.


Write to us