Extracting data from SW non-excel BOM
Extracting data from SW non-excel BOM
(OP)
We have a macro that connects to the Excel BOM in an assembly drawing and transfers that information into an Excel spreadsheet assigning each piece of info to its specific column.
Is there a way to do something similar to assembly drawings using the new non-excel BOM?
Is there a way to do something similar to assembly drawings using the new non-excel BOM?






RE: Extracting data from SW non-excel BOM
RE: Extracting data from SW non-excel BOM
RE: Extracting data from SW non-excel BOM
Bradley
RE: Extracting data from SW non-excel BOM
RE: Extracting data from SW non-excel BOM
To save a bom as a .csv
Select the bom and then do a File, Saveas, change the extension to .csv
RE: Extracting data from SW non-excel BOM
Highlight the view, in SolidWorks main menu, click Insert, Tables, Excel Based Bill of Materials…
Bradley
RE: Extracting data from SW non-excel BOM
RE: Extracting data from SW non-excel BOM
Thanks,
Matt
RE: Extracting data from SW non-excel BOM
To my knowledge you cannot get each configuration of a part to show up as a separate line item on the same BOM.
Bradley
RE: Extracting data from SW non-excel BOM
RE: Extracting data from SW non-excel BOM
retval = BomTable.GetEntryText ( row, col)
Can't be hard to create a SW and an Excel object get the values from sw and past them in excel using a macro