Whether it's possible to branch the workflow based on the content of cells in an attached Excel

[DH_10667582]

I am using Windchill PDMLink Release 11.0 and Datecode with CPS N/A

In the scenario of customizing workflows in PTC PDMLink with Java coding, is it possible to make decisions in the workflow based on the contents of cells in an attached Excel sheet? Or, is it feasible to retrieve the contents of cells from an Excel sheet attached to the workflow?

[Hari_Vara]

Hi there,

Good scenario. What I think is a possibility is to do a Excel Macro that extracts the Cell Value and populates it to a WTDocument Attribute. Then its a home run in Windchill using Expression Robots.

I am keen to hear other approaches here from experts, probably they might have come across this already.

Best Regards

Hari

[HelesicPetr · Accepted solution]

Hi @DH_10667582 

Yes it is possible.

You just need to write own class and code where you find the attached excel,

Open the excel read the cell and check what value is in the cell. 

You just need to know how to write the code, but it is possible.

there are some APIs to read a excel based on the type. XLSx or XLS

// XLSx
org.apache.poi.xssf.usermodel.XSSFWorkbook
//XLS
org.apache.poi.hssf.usermodel.HSSFWorkbook

PetrH