It might be best to get the expressions converted to values, using an Excel Macro, before the spreadsheet is read by ITX. (
https://www.mrexcel.com/board/threads/remove-all-formula-in-entire-workbook.1027663/)
If the expressions cannot be evaluated using an Excel macro, then the sums will have to be solved when the data comes into ITX. You could perhaps use the SHELL/BATCH adapter to call out to a command line calculator. Alternatively, you could use a JEXIT to an appropriate Java Class that will solve math presented as a string (
https://www.objecthunter.net/exp4j/). You could also log an enhancement request on the A-Ha! website (
https://ibm.biz/ITX-RFE) to get an EVAL() function created.
------------------------------
Paul Brett
IBM Sterling Transformation Extender (ITX) Client Support
------------------------------
Original Message:
Sent: Thu July 09, 2020 11:16 AM
From: Hemachandra C G
Subject: ITX - Excel adapter data read and write
Hi Team,
My input is Excel (excel adapter). Excel cell is having mathematical functions (ex: =100+200-50). While execution data is reading as 100+200-50. But my requirement is to map the final value i.e 250.
Source type tree field data type is Text. As it is Text format I could not able to do calculation.
Please let me if you have come across this kind of scenario's earlier.
------------------------------
Hemachandra G
------------------------------
#B2BIntegration
#SupplyChain