Automate

 View Only

  • 1.  Data read/write and Excel with hidden columns

    Posted 08-13-2021 06:58
    Hi

    have anyone tested how Transaction works with Excel if some of the data columns are hidden?
    My experience shows that Winshuttle can read from SAP to hidden Excel columns, it can also properly recognize columns used for IF conditions, but it cannot write to SAP from hidden Excel columns. Can someone confirm this inconsistency?

    PM

    ------------------------------
    Pawel Musial | Computational Wizard
    Signify Netherlands B.V. | +31640751720
    ------------------------------


  • 2.  RE: Data read/write and Excel with hidden columns

    Posted 08-13-2021 08:03
    Hi Pawel, I tried it: We can write to SAP from within a hidden Excel column with a Studo script.

    ------------------------------
    jan ketele | Sr engineer release mgt
    Xeikon Manufacturing NV | +32 34 43 1 875
    ------------------------------

    Original Message


  • 3.  RE: Data read/write and Excel with hidden columns

    Posted 08-13-2021 08:15
    Thanks Jan,

    I'm on Studio version 12.1 64bit and you?

    ------------------------------
    Pawel Musial | Computational Wizard
    Signify Netherlands B.V. | +31640751720
    ------------------------------

    Original Message


  • 4.  RE: Data read/write and Excel with hidden columns

    Posted 08-16-2021 05:46
    Hi Pawel,

    I'm on Studio 12.1 32 bit.
    and to be complete: Excel is Office professional plus 2013, 32 bit

    best regards, jan

    ------------------------------
    jan ketele | Sr engineer release mgt
    Xeikon Manufacturing NV | +32 34 43 1 875
    ------------------------------

    Original Message