Inventor General Discussion

Inventor General Discussion

Reply
Distinguished Contributor
kellyhoyer
Posts: 111
Registered: ‎01-11-2001
Message 1 of 4 (30 Views)

Parameter Links

30 Views, 3 Replies
11-12-2004 11:29 AM
I would like to use the Link function in the parameters dialog and point it to an .xls file full of numbers so that I can get the part that I'm drawing to change length.

I have created an .XLS file with a single row of numbers, starting at A1.

I have gone into my parameters dialog and added the .XLS file through the Link feature. It regenerates and creates a folder in the parameters area, but has no fields underneath. It is empty.

I most be missing something. I have followed to the detail what the help menu is telling me to do.

Help, please.

Kelly Hoyer
*Donovan Cox
Message 2 of 4 (30 Views)

Re: Parameter Links

11-12-2004 11:48 AM in reply to: kellyhoyer
there a check box that causes Inventor to only show parameters that are in use, is that checked off? The other thing could be that you have your parameters in the wrong format, it should be 1) parameter name 2)value 3) unit 4) comments "kellyhoyer" wrote in message news:25784172.1100287778324.JavaMail.jive@jiveforum2.autodesk.com... >I would like to use the Link function in the parameters dialog and point it >to an .xls file full of numbers so that I can get the part that I'm drawing >to change length. > > I have created an .XLS file with a single row of numbers, starting at A1. > > I have gone into my parameters dialog and added the .XLS file through the > Link feature. It regenerates and creates a folder in the parameters area, > but has no fields underneath. It is empty. > > I most be missing something. I have followed to the detail what the help > menu is telling me to do. > > Help, please. > > Kelly Hoyer
Distinguished Contributor
kellyhoyer
Posts: 111
Registered: ‎01-11-2001
Message 3 of 4 (30 Views)

Re: Parameter Links

11-12-2004 12:43 PM in reply to: kellyhoyer
Thank you for your response.

Are you saying that my data has to be in a certain format in Excel? If so, could you or someone attach perhaps a dummy excel file so that I can see the required format.

I'm still getting nothing. I know about the check box.

Thank you.

Kelly Hoyer
*Quinn Zander
Message 4 of 4 (30 Views)

Re: Parameter Links

11-12-2004 01:04 PM in reply to: kellyhoyer
Your spreadsheet must be setup like the Parameters Dialog, except different. (Why different is something that has been strange from the beginning) Wherever you specify the "Start" cell, the sheet NEEDS to be in this format: First Column -Parameter Name. Second Column -Value Third Column -Units Fourth Column -Comments (optional) The difference is that the Value and Units columns are reversed between the Parameters Dialog and a setup spreadsheet. As soon as IV sees a space anywhere in this "block" of data, it will stop looking/linking the cells. This means you can have "calculating" data in tables or whatever on top, the side, or the bottom of the "block" as long as at least one empty cell/row seperates the linked block of data between the other reference data. QBZ "kellyhoyer" wrote in message news:6415149.1100292217504.JavaMail.jive@jiveforum2.autodesk.com... > Thank you for your response. > > Are you saying that my data has to be in a certain format in Excel? If so, could you or someone attach perhaps a dummy excel file so that I can see the required format. > > I'm still getting nothing. I know about the check box. > > Thank you. > > Kelly Hoyer
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.