Welcome to MCAD Central

Join our MCAD Central community forums, the largest resource for MCAD (Mechanical Computer-Aided Design) professionals, including files, forums, jobs, articles, calendar, and more.

Register Log in

Maybe you'll know how!

cole_trick

New member
I have a single drawing file creating a complete folder for the production. this file use relation and pro/program to create via parameters, all the neede drawing and the bill of material (by also controling layers). The enterprise just made the buying of a new MRP software to control the inventory, and we want to take the text inside bill the material to be convert as Excel file to control inventory.



if someone know how to save text include in a table of a pro/e drawing as Excel or an other software...please guide me



cole
 

eServ

New member
If you are running 2000i2 or 2001, you can go to the family table and go up to: File/Edit with Excel, this will open up an Excel document of the family table contents. From their you can save the Excel document as whatever. Try that, I think it will work. Let me know.
 

cole_trick

New member
Thank a lot eServ but, we don't use a family table is a simple table create in drawing mode...thanks anyway

(and i'm on pro/e 2000i
 

eServ

New member
Sorry about that. I've heard from somone before that you can take a table in a drawing and convert it to an Excel document, but I haven't figured out how to do it.
 

tham

New member
Try this: (Works in 2001)



From the Menu Manager: TABLE > SAVE/RETRIEVE > STORE TEXT

Then select the table and give the file a name.



From Excel, select FILE > OPEN

change the file type to ALL FILES and select the file you just stored in Pro-E.



It will import it into spreadsheet form.
 

cole_trick

New member
GOOD TODDHAMMER!!!!!, you show me something verry useful. but the problem reside, in this table i move notes in empty cell because i can't controle the content of a cell by layers so thoses notes (parameter driven notes like &XXXXXXX you know) don't transfer in Excel.
 

msexton

New member
Try controlling the content using Sim Reps rather than layers.



If you are using IntraLink then what you are wanting can be done using Toolkit.



If not using ILink then you need to contact PTC and have them write you a program for the translation.
 

cole_trick

New member
Thanks msexton, i'm not familiar with yours topics (sim reps, Intralink, Ilink) but i'm going to search about it!



If there's anything you trap in, just ask...



Thanks a lot, Cole!
 

Sponsor

Top