cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

How to open BOM file created in Microsoft Excel in creo drawing?

sbhattacharya-2
3-Visitor

How to open BOM file created in Microsoft Excel in creo drawing?

Hi Creo Users,

In various cad softwares, any holetable, bom, sheetmetal bend tables which are created in microsoft excel  can easily be read and  linked in drawing modules in cad softwares.

In creo drawing there is a table option which open only .tbl file. How to create that .tbl file manually?

Is there any other way to open or link ms excel file in creo drawing as bom or other table?

In the other discussions about excel tables that I have searched with the help of search bar,  other Creo users say that first you have to convert excel file to .csv. Why? Cannot we directly open ms excel files?

With regards,

Soumya

4 REPLIES 4

You can save the excel file as .csv format and you can import this .csv into Creo drawing using Table->Table From file

I haven't heard or used any other way to import excel into Creo directly.

Hi,

you can insert Excel file into Creo drawing using standard OLE functionality (Insert > Object). Look into PTC Help.

MH


Martin Hanák

.tbl files are not just text files. They are a PTC specific file that is encoded so that only PTC software can open and or create them.

Mostly just collating the excellent responses so far:  Creo tables can do things that Excel can't, like setting up instructions for traversing the assembly to make a bill of materials.  Excel can do things that Creo tables can't, like being a spreadsheet and referencing the values from cells in formulae to drive other values.  To make a .tbl file, make a table in your drawing, and save it as .tbl. The reason for this is to be able to reuse the table in another drawing without needing to recreate it.  You can put an Excel spreadsheet in your drawing directly, via OLE.  If you want to start with an Excel spreadsheet and end up with a Creo table, you can get the arrangement of cells in the grid and the text in each via .csv.

Right now, that's what you've got to work with.  It is a reasonable enhancement request that we look to implementing an import from .xlsx, which would provide column widths, merged cells, note text style, and the like.  This would be a significant amount of work, but could benefit a number of customers.  Such a proposal would be made a 'product idea', or brought up with the TCs, or the like.

Top Tags