CatDrawing BOM to Excel

[gbaerg]

Hi everyone

I am looking for a way to export the data from a drawing table in a catdrawing into excel. any ideas?

Thanks
Greg

 

[itsmyjob]

we do have a script to do this... and also the Exel to Drawing Table...

Editing Drawing Table is a pain!

Eric N.
indocti discant et ament meminisse periti ​

 

[gbaerg]

do you have any suggestions to help get started on writing a script for this?

 

[itsmyjob]

see FAQ...

Eric N.
indocti discant et ament meminisse periti ​

 

[brengine]

In the Product, you can go to Analyze/Bill of Material, and at the bottom there is a SaveAs button. Excel is one of the available file types.

Ken

 

[tuzoenduro]

itsmyjob, can you guide me a little bit in how to import text from a file to a drawing table?? as far as I can go is to do the whole "insert object" thing but this leaves me with an image which I later have to resize to fit...

How do I go to recuperate text from a regular txt file sepparated by tabs and insert it in a drawing table on the drafting workbench??

Thanx for your help

regards, luis

 

[itsmyjob]

for your script you should work at the drawingtable level.

open your text file.
get the first line
find the next tab, do some text manipulation with mid()
put the text in the proper cell CATDrawingTable.SetCellString()
go to next tab in text and next Column in drawingtable
go to next line in text file and next Row in Table

Eric N.
indocti discant et ament meminisse periti ​