Linking SW with external Excel file
Linking SW with external Excel file
(OP)
How can I link the SolidWorks properties (for example: $PRPSHEET:"SW-File Name") to an external Excel file? What I am looking for is the ability to fill in SolidWorks properties and have the Excel file be filled in automatically.
Bradley






RE: Linking SW with external Excel file
Regards,
Scott Baugh, CSWP

http://www.3dvisiontech.com
http://www.scottjbaugh.com
FAQ731-376
RE: Linking SW with external Excel file
Bradley
RE: Linking SW with external Excel file
Bradley
From your original post I got the impression you were trying to populate an external Excel spreadsheet from a model parts custom properties. If that's correct, then simply create a DT from your part, then save it as a seperate excel file.
If, however, you want to populate a parts DT from an external spreadsheet then:-
Open the parts DT.
Open the external spreadsheet.
In the parts DT highlight a cell & type =.
Activate the external spreadsheet.
Click the cell with the data you want referenced.
Hit Enter on your keyboard.
Parts DT should now show external cell data.
Good Luck
CorBlimeyLimey, Barrie, Ontario.
FAQ559-863
RE: Linking SW with external Excel file
Your 1st statement is right. I would like to use the DT to populate the external Excel spreadsheet. However I could not get any properties to show up on the DT.
I tried your 2nd method of “In the parts DT highlight a cell & type =”
The DT did not change at all. The cell was blank.
Bradley
RE: Linking SW with external Excel file
A couple of pointers - You should make sure you open your DT in a separate window so you get all the Excel tool bar, etc. Also note that you can have multiple sheets in a DT, but SW will only ever use the first sheet for the DT. Finally the downside to external DT's is that you have to do more careful file management.
John Richards Sr. Mech. Engr.
Rockwell Collins Flight Dynamics
A hobbit's lifestyle sounds rather pleasant...... it's the hairy feet that turn me off.
RE: Linking SW with external Excel file
I've lost count of the number of times you've posted a similar reply regarding link direction of DT's. Perhaps you should post an FAQ about it.
Even if no-one checks the FAQ before they post, at least you could simply refer them to FAQ559-xxxx and save the wear & tear on your fingers.
CorBlimeyLimey, Barrie, Ontario.
FAQ559-863
RE: Linking SW with external Excel file
"Your 1st statement is right. I would like to use the DT to populate the external Excel spreadsheet. However I could not get any properties to show up on the DT."
After creating your part & typing in the properties you want, insert a DT. Make sure Auto-create is selected in the Source section & that New parameters & New configurations are selected in the Options section. Click the Green check mark. A blank DT should appear. Now RMB on the DT icon in the Feature Manager & select Edit Table. A "Add Rows and Columns" dialogue box should appear and it should have a list of all the properties related to the part. Highlight all the ones that you want to include in the DT. Click the Show unselected items again then click OK.
Your DT should now be populated with your chosen properties.
Let us know if this works.
CorBlimeyLimey, Barrie, Ontario.
FAQ559-863
RE: Linking SW with external Excel file
In the Add Rows and Columns dialog under configurations there is only "Default". In the Parameters dialog there is all my Configuration Specific properties. When I pick them they do show up in the design table.
Bradley
RE: Linking SW with external Excel file
Try deleting your CSP's and have only Custom Props or move your Custom Props to CSP.
CorBlimeyLimey, Barrie, Ontario.
FAQ559-863
RE: Linking SW with external Excel file
I am trying to write a Visual Basic 6.0 program to read the properties and insert the data into an Excel form. This may do the trick.
Thanks for you help CorBlimeyLimey,
Bradley
RE: Linking SW with external Excel file
John Richards Sr. Mech. Engr.
Rockwell Collins Flight Dynamics
A hobbit's lifestyle sounds rather pleasant...... it's the hairy feet that turn me off.