Exporting Solid Works BOM to Excel
Exporting Solid Works BOM to Excel
(OP)
using sw2007 sp3.0 i have been coping and pasting sw bom from bom contents to excel. Is there a way to directly export sw bom to excel?
When was the last time you drove down the highway without seeing a commercial truck hauling goods?
Download nowINTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Exporting Solid Works BOM to Excel
|
Exporting Solid Works BOM to ExcelExporting Solid Works BOM to Excel(OP)
using sw2007 sp3.0 i have been coping and pasting sw bom from bom contents to excel. Is there a way to directly export sw bom to excel?
Red Flag SubmittedThank you for helping keep Eng-Tips Forums free from inappropriate posts. Reply To This ThreadPosting in the Eng-Tips forums is a member-only feature.Click Here to join Eng-Tips and talk with other members! |
ResourcesWhat is rapid injection molding? For engineers working with tight product design timelines, rapid injection molding can be a critical tool for prototyping and testing functional models. Download Now
The world has changed considerably since the 1980s, when CAD first started displacing drafting tables. Download Now
Prototyping has always been a critical part of product development. Download Now
As the cloud is increasingly adopted for product development, questions remain as to just how cloud software tools compare to on-premise solutions. Download Now
|
RE: Exporting Solid Works BOM to Excel
You can save the BOM out as a CSV or text file and import it into Excel. If you know API programming, you can write a routine (it may already be posted in the forum somewhere)and directly transfer it.
Regards,
Regg
RE: Exporting Solid Works BOM to Excel
RE: Exporting Solid Works BOM to Excel
You do not right click. You left click on the BOM then go to file-save as. Then make sure you change "save as file type" to .csv. Then save the file where ever you would like. One thing that I noticed. I am running 2006 sp4.0 and when I open the .csv file in excel the cells will not load properly if I have a comma in the fields. I imagine the comma tells Excel to move to the next cell because that is what happens to me. If I remove all commas I have no problems.
Take care
RE: Exporting Solid Works BOM to Excel
RE: Exporting Solid Works BOM to Excel
Since you are running SW 2007 you can save the BOM directly to an excel file by using the file save as ".xls" command. This puts all data in the proper place on the excel file and commas are accepted. Let me know if you have any questions.
Mike G.
RE: Exporting Solid Works BOM to Excel
RE: Exporting Solid Works BOM to Excel
Thank you for the info. You are correct saving as txt eliminates my problem. A star for you.
RE: Exporting Solid Works BOM to Excel
Since I have a macro that does this, I did not know that you could now save BOM table as xls. Have a star.
Regards,
Regg