Reading points from spreadsheet - NX4

[VitaminM]

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")
?

 

[JohnRBaker]

This might be possible starting with NX 5 since string valued Expressions were introduced at that time. However, they were not yet supported in NX 4.

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.

 

[VitaminM]

How about this one then:
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)?