I was attempting to create a special BOM in a drawing tosupplement the true BOM. (it was to show the materials needed for aprototype we are creating, and some of the items are substitutions)
I first exported the "real" BOM, and then opened it in Excel. Then,I tried, without success, to find a way to get this informationback into SW. I found I could not past a copied set of cells fromExcel into a general table. Doing so only inserted the entire textof the Excel table into one cell (only one cell at a time will workproperly). I tried just pasting the cells, without first startinganything in SW, but nothing happened. Then, I just pasted the cellsinto a text box, and changed it to Courier font, and manually addedspaces until the columns lined up.
There has got to be a better way! Am I missing something obvious?
[I found it! Pasting DID WORK! I didn't notice it at first becauseSW put the embedded Excel table way out in left field outside ofthe drawing sheet. It didn't show up until I did a Zoom to Fit.]
Joe DunfeeSolidworksBill Of Materials
I first exported the "real" BOM, and then opened it in Excel. Then,I tried, without success, to find a way to get this informationback into SW. I found I could not past a copied set of cells fromExcel into a general table. Doing so only inserted the entire textof the Excel table into one cell (only one cell at a time will workproperly). I tried just pasting the cells, without first startinganything in SW, but nothing happened. Then, I just pasted the cellsinto a text box, and changed it to Courier font, and manually addedspaces until the columns lined up.
There has got to be a better way! Am I missing something obvious?
[I found it! Pasting DID WORK! I didn't notice it at first becauseSW put the embedded Excel table way out in left field outside ofthe drawing sheet. It didn't show up until I did a Zoom to Fit.]
Joe DunfeeSolidworksBill Of Materials
