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

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

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

mprasad
10-Marble

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

2 REPLIES 2

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

ddemay
7-Bedrock
(To:mprasad)

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.

Announcements

Top Tags