Cancel
Showing results for 
Search instead for 
Did you mean: 

Bom Export to excel

Solution Partner Pioneer Solution Partner Pioneer
Solution Partner Pioneer

Hello,

 I have Bom of an assembly, which i want to export to excel but i dont know how to do it. I searched a lot on internet about it but couldnt find the solution.

 please help me with my problem.

 

Thanks and regards

Ashish Sarode

6 REPLIES

Re: Bom Export to excel

Phenom
Phenom
just right click on the BOM and select "Copy text" then open excel, right click on any cel and select "Paste".

Re: Bom Export to excel

Solution Partner Pioneer Solution Partner Pioneer
Solution Partner Pioneer
Hi,

Thankyou for the solution. But after pasting the bom in excel. It is
appearing like a picture, and not like as we get while using variable
contents in excel.

Kindly reply.



Thanks and regards,

Ashish Sarode

Re: Bom Export to excel

Phenom
Phenom

@iashishsarode1 wrote:
Hi,

Thankyou for the solution. But after pasting the bom in excel. It is
appearing like a picture, and not like as we get while using variable
contents in excel.

Kindly reply.



Thanks and regards,

Ashish Sarode

 

This happen because you have selected "Copy" and not "Copy content" on the BOM.

 

Try again :-)

Re: Bom Export to excel

Solution Partner Legend Solution Partner Legend
Solution Partner Legend

We already released a little tool for free for the BOM export to Excel.

 

Creates the BOM from the Solid Edge assembly within Excel.

 

You can configure the BOM including:

  • All properties
  • Physical properties like mass or area
  • preview of the parts
  • hierarchy
  • item number
  • table style
  • etc.

An example as PDF is here!

 

 BOM-Bild.jpg

 

You can download the Excel-Makro here for free:

http://www.all4edge.de/downloads/projekt-stuecklisten/

 

You just have to register and you will get the download link.

 

Some details in the video

 


(view in My Videos)

  Stefan

 

 

 

smitsch@unitec.de
www.all4edge.de

Re: Bom Export to excel

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

Hi @Stefan_Mitsch

 

 

 

thanks for that really good tool.

I am 100% confident that there are many people who will and can use this tool.

 

 



regards
Wolfgang

Re: Bom Export to excel

Solution Partner Legend Solution Partner Legend
Solution Partner Legend

I got some messages about the preview images.

 

To extract the images from the Solid Edge files we developed little DLL. And this DLL has to be registered before you are using the Add-In in Excel. Otherwise there are no preview images.

 

All details about this are in the delivered Readme.txt.

 

Please have a look.

 

Stefan

 

smitsch@unitec.de
www.all4edge.de