I'm not really sure if this should go into this forum
category but here goes anyway.
We hae developed an Excel spreadsheet (refer attachment) for the drawings that we have for our motors that we have manufactured for us. At the present we have developed a spreadsheet then cut and paste it into the drawing sheet which becomes part of the drawing template for all users. This works fairly well but will tend to leave a border around the imported object which we don't want. Also the spreadsheet if it's having a bad day can resize itself which can be a pain trying to get it back to the orginal size.
The question is, "Can the spreadsheet be converted to a SW table???"
If anyone out there in the WWW has any expert advise on being able to do this I apprieciate your words of wisdom.
We hae developed an Excel spreadsheet (refer attachment) for the drawings that we have for our motors that we have manufactured for us. At the present we have developed a spreadsheet then cut and paste it into the drawing sheet which becomes part of the drawing template for all users. This works fairly well but will tend to leave a border around the imported object which we don't want. Also the spreadsheet if it's having a bad day can resize itself which can be a pain trying to get it back to the orginal size.
The question is, "Can the spreadsheet be converted to a SW table???"
If anyone out there in the WWW has any expert advise on being able to do this I apprieciate your words of wisdom.
You can't paste into Solidworks, but you can paste special into AutoCAD 2005 or later as a table object (you can paste special into 2004 or earlier but it ain't pretty) Once you've done that, you can insert the AutoCAD drawing into a solidworks drawing as a block.
If you're going to add any field data, better do it while you're still in Excel.
We use AutoCAD 2000 at our shop, but we run a plug-in called AutoTable XLS ($250- http://www.cadaddon.com) I imported your table into solidworks using that route. See attached.
Good luck.
John