Using Excel Files
Using Excel Files
(OP)
Is it possible to have SW read a specific excel cell? For instance, if I want my pipe thickness to read excel cell A25 and the pipe diameter to read cell J43.
In other words I would like to use one externally linked excel summary sheet to drive multiple part drawings and assembly drawings.
Thanks!
In other words I would like to use one externally linked excel summary sheet to drive multiple part drawings and assembly drawings.
Thanks!






RE: Using Excel Files
Regards,
Scott Baugh, CSWP![[pc2] pc2](https://www.tipmaster.com/images/pc2.gif)
www.scottjbaugh.com
FAQ731-376
RE: Using Excel Files
You cannot drive part or assy drawings with an excel file. You can however, drive part or assy models with Design Tables which in turn will drive the drawings.
A Design Table can be linked to an external Excel spreadsheet, and the data used to drive the properties, dimensions, etc of a part or assembly model.
RE: Using Excel Files
1.) I linked my external excel spreadsheet file to my part. The excel file has values which I would like to use to drive my part on random cells. (ex. B2, C18, A4 etc..)
2.) Next, I tried to link a specific dimension in my model to a specific cell in the design table. The procedure I used was:
a.) selected the SW part to activate the dimension.
b.) once the dimension was activated, I double clicked
on it so that I can link it to the cell of my
choice in the design table.
Here is the error that pops up:
"Server Busy:
This action cannot be completed because the other program is bust. Choose 'switch to' to activate the busy program and correct the problem"
The interesting thing is that SW is the only program I have open. I closed the excel file after I linked it.
Can anyone tell me what I am doing wrong??
Thanks
RE: Using Excel Files
RE: Using Excel Files
Thanks