cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to generate BOM in Excel format through Windchill API's

Regular Member

How to generate BOM in Excel format through Windchill API's

Through Windchill code I would Like to retrieve all child Item of a given Part/Assembly and later put it into excel file and save it to a particular location. Please guide me how to do this

Tags (1)
2 REPLIES 2

Re: How to generate BOM in Excel format through Windchill API's

Hi Manish,

One of the ways to generate the BOM is using Info*Engine Query-Tree Webject. You can then parse the output and create the Excel file.

Regards,

Bhushan

Re: How to generate BOM in Excel format through Windchill API's

Follow the action(s) for viewing BoM and, export to Excel / CSV / whatever using the action model, follow those classes by debugging, logging verbosity, and can decompile those classes keepingin mind to not duplicate any code as it is seen.  It should direct you to the unsupported but core service classes that fetch the data via a complex query statement and returns the data from database.

Info*Engine easiest way to do this given it's the backbone of the Business Intelligence reports.  No need to use JSP, can invoke Info*Engine from Java class.