extract BOM data to Excel
CADForums.net Forum Index CADForums.net
Discussion of AutoCAD and other CAD software.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web cadforums.net
extract BOM data to Excel

 
Post new topic   Reply to topic    CADForums.net Forum Index -> SolidWorks
Author Message
Steve Reinisch
Guest
Posted: Tue Nov 22, 2005 9:10 pm    Post subject: extract BOM data to Excel Reply with quote
Is it possible to extract BOM attributes from assy or part files to an Excel
spread sheet?

Steve R

Back to top
John Kreutzberger
Guest
Posted: Tue Nov 22, 2005 9:10 pm    Post subject: Re: extract BOM data to Excel Reply with quote
Quote:
Is it possible to extract BOM attributes from assy or part files to an
Excel
spread sheet?

Steve R
So, are you trying to skip the step of creating a drawing?


jk
Back to top
Steve Reinisch
Guest
Posted: Tue Nov 22, 2005 9:10 pm    Post subject: Re: extract BOM data to Excel Reply with quote
to clarify, I would also like to maintain a link to th ebom in excel such
that changes in th eBOM will be reflected in the spreadsheet.


"Steve Reinisch" <stever@davis-eng.on.ca> wrote in message
news:AsadnQJOYLX36B7enZ2dnUVZ_tSdnZ2d@magma.ca...
Quote:
Is it possible to extract BOM attributes from assy or part files to an
Excel spread sheet?

Steve R


Back to top
Jess G. Frandsen
Guest
Posted: Sun Nov 27, 2005 9:10 am    Post subject: Re: extract BOM data to Excel Reply with quote
Hi Steve,

Please take a look at our Gold Partner product ToolWorks BOM Manager.

http://www.toolworks.info

Using this add-on you are able to export BOM from an Assembly without
creating the drawing. Also ToolWorks BOM Manager offers a command-feature
that can be triggered from ourside of SolidWorks to keep your MS-Excel BOM's
up-to-date.

Best regards
Jess G. Frandsen



"Steve Reinisch" <stever@davis-eng.on.ca> wrote in message
news:AsadnQJOYLX36B7enZ2dnUVZ_tSdnZ2d@magma.ca...
Quote:
Is it possible to extract BOM attributes from assy or part files to an
Excel spread sheet?

Steve R
Back to top
TOP
Guest
Posted: Sun Nov 27, 2005 1:10 pm    Post subject: Re: extract BOM data to Excel Reply with quote
I have done this with a macro.In a nutshell the macro reads every
single instance of every component, suppressed or not and then I use an
awk script to determine the count of all the resolved and lightweight
components. Then I read the resulting text file into Excel. It works
because I name configurations with the part name.

The reason I do it this way is that awk can plow through thousands of
items much quicker than Excel can and requires a lot less programming.

The VB program I use as a basis for all this is found in the Online
Help for the SolidWorks API and then modified. It will read custom
properties which I think you are asking for.
Back to top
 
Post new topic   Reply to topic    CADForums.net Forum Index -> SolidWorks All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




Windows Server DSP VoIP Electronics New Topics
Contact Us
Powered by phpBB