Automate Drawings from Spreadsheet
Automate Drawings from Spreadsheet
(OP)
I have been trying to automate a process of making around 2000 drawings with dimensions in an excel spreadsheet. I have a master template but need to change a few dimensions in each drawing.I have tried to use part families but I can not effeciently generate drawings using this method. Is there a better way to import/link the spreadsheet data to these parts?
Jake Clever
Product Engineer
Jake Clever
Product Engineer





RE: Automate Drawings from Spreadsheet
And what version of NX are you using?
John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.com/museum/
To an Engineer, the glass is twice as big as it needs to be.
RE: Automate Drawings from Spreadsheet
I am using version 5 but have version 7.5 capability if there is a newer function to make this possible.
RE: Automate Drawings from Spreadsheet
John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.com/museum/
To an Engineer, the glass is twice as big as it needs to be.
RE: Automate Drawings from Spreadsheet
Included is a part file (model1.prt) which is NX7.5 part. This part has a simple block in it and a drawing with two dimensioned views of the block.
The xls data for three versions of the block are included in data1.xlsx. The program looks for this xls file in C:\temp\
To read the xls file we need to use a Microsoft namespace. This means the program cannot be run as a journal. I have included the source code (PDFCreate.txt). Just change the txt extension to vb for reference. The pdfcreate.dll has been signed so that the sample program can be run (NX7.5).
Frank Swinkels
RE: Automate Drawings from Spreadsheet
Thank you for the sample program. I tried to execute it but it came back with an error, most likely due to something I am doing despite your efforts. I appologize for that. I have attached a picture of what I am getting back from NX when I execute the program as an NX open.
Thanks for all your help!
Jake Clever
RE: Automate Drawings from Spreadsheet
Hope this now works.
Frank Swinkels
RE: Automate Drawings from Spreadsheet
RE: Automate Drawings from Spreadsheet
Frank Swinkels
RE: Automate Drawings from Spreadsheet
Thank you for all your help!