Bablosoft

Multi column Excel file

Support
  • K

    Hi, so I have an excel file, and I have over 1000 columns in this file. I codded the script to read A1 B1 C1 D1 and lets say L1, everything works perfectly but what I want is script should go to second column like A2 B2 C2 D2 and L2. I can do it manually but doing this 1000 times might give me cancer. So I was wondering if there is an easier way to do it?

    My function works this way;

    Read cell A1 and type it to this element
    Read cell B1 and type it to this element.

    When this is over, it should go to A2 and B2 then A3 and B3 and on and on..

    G 1 Reply
    0
  • G

    @korkmazzenci, like this excel_cycle.xml. The cycle starts at 0 since index = number - 1. You can also use the actions that read several cells at once "Read sheet", "Read cells range", "Read rows".

    0
  • K

    I fixed my problem by deleting the first row everytime Im done with it. So now I create a excel file, everytime script works on first row, it deletes it and second row becomes first one and works like that.

    0