AnsweredAssumed Answered

Import Excel BOM to Solidworks Drawing

Question asked by Ryan McCauley on Jan 5, 2012
Latest reply on May 8, 2013 by David St Hilaire

We have our BOM made in Excel and instead of spending 2 days (atleast) making new tables in multiple sheets, I would rather import the entire excel sheet as a large table and sort it into multiple drawing sheets. As an end result, I will be saving as a .dwg and loading into draftsight to send to a customer who uses AutoCAD. Anyone know if this is possible?

 

My plan would be:

1. Load large table from Excel into a new SolidWorks Drawing file and saving as a DWG/DXF.

2. Open this with DraftSight.

3. Sort the tables into different pages in DraftSight before sending to customer.

 

Any ideas on how to do step 1?

Outcomes