B2B Integration

 View Only

  • 1.  ITX - Excel adapter data read and write

    Posted Thu July 09, 2020 11:16 AM
    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


  • 2.  RE: ITX - Excel adapter data read and write

    IBM Champion
    Posted Mon July 13, 2020 11:47 AM
    Edited by System Wed March 22, 2023 11:56 AM
    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


  • 3.  RE: ITX - Excel adapter data read and write

    Posted Fri July 17, 2020 04:51 AM
    Thank you so much Paul :)

    ------------------------------
    Hemachandra C G
    ------------------------------

    Original Message