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?