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.