Reading points from spreadsheet - NX4
Reading points from spreadsheet - NX4
(OP)
I've modeled an impeller blade using x,y,z points read from an Excel spreadsheet. My goal is to have a model that can be used for many impellers simply by changing the Excel file.
A typical parameter is defined as follows:
p20 = ug_cell_read("C:\My Documents\spreadsheet.xls", "AE31")
Other users won't store their spreadsheets as "C:\My Documents...." but rather as a different filename.
Can I create a parameter that defines the filename/location? Something like...
p21 = "spreadsheet.xls"
p22 = ug_cell_read("p21", "AE31")
?
A typical parameter is defined as follows:
p20 = ug_cell_read("C:\My Documents\spreadsheet.xls", "AE31")
Other users won't store their spreadsheets as "C:\My Documents...." but rather as a different filename.
Can I create a parameter that defines the filename/location? Something like...
p21 = "spreadsheet.xls"
p22 = ug_cell_read("p21", "AE31")
?





RE: Reading points from spreadsheet - NX4
John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/
To an Engineer, the glass is twice as big as it needs to be.
RE: Reading points from spreadsheet - NX4
Is there a way to allow the number of rows in Excel govern the number of points in the model?
Right now, I have 24 points so I MUST have 24 rows in excel. I'd like to allow for more rows.
So if the excel file has 100 rows, the model should generate 100 points. Is this possible (in NX4 or other version)?