Windchill 10.1 - Auto Generate ECN Summary Report in excel format

[arajagopal]

Currently Windchill 10.1 API only supports generating the report in pdf format and not in excel format. But Windchill report UI supports both pdf and excel formats.

We are trying to automate ECN summary report in ECN workflow and currently API only supports generating report as a pdf file and attach to ECN. Since there is no API to support generating report in excel we are not able to auto generate report in excel within ECN workflow. Our business users want report in excel form and not in pdf.

The available API to support report generation is.

wt.change2.reports.ReportHandlerFactory.getInstance().handleReport(primaryBusinessObject, "Change Notice Summary Report", wt.content.ContentRoleType.SECONDARY,((wt.change2.ChangeOrder2)primaryBusinessObject).getNumber()+".pdf");

It would be nicer to have similar API for .xlsx file. I think it is already there and it is not exposed to outside since UI is able to do same functionality of generating report in excel form.

Here is UI to generate report in both pdf and excel form.

Thanks

Ayyappan

[arajagopal]

Thanks for the comment. I did vote up now.

[JeffZemsky]

We have no plans to support beyond the PDF format.

[olivierlp]

Hello,

We are archiving your idea as part of a general review. This action is based on the age of your idea and the total number of votes received, as per this announcement.

You can always post a new idea with all the details required in the form.

Thank you for your participation.