Skip to main content
12-Amethyst
July 19, 2016
Question

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

  • July 19, 2016
  • 2 replies
  • 2481 views

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

16-Pearl
July 20, 2016

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

1-Visitor
August 16, 2016

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.