Forum Discussion

hskim's avatar
hskim
Contributor
10 years ago

How can I control the Input position in Excel?

Hi I use two colum in Excel. Colum A is inputted from web data. Colum B is inputted by tester.   When executing testcase, the web data is inputted to Excel(Column A) and then the values in Colum...
  • djadhav's avatar
    djadhav
    Regular Contributor
    10 years ago

    If you are using rowCount for output row number then

    rowCount = 1 should do it for you. From there you can keep incrementing it.

     

    In case that is not true, please paste some code where you are writing the values to Excel.

    • hskim's avatar
      hskim
      Contributor
      10 years ago

      I tried to fix the value like 'rowCount = 1'.

      And then the result is written at that just one time.

      After that 2rd result is written same position the 1th result is gone.

       

      I want to writ the 1th result from 1 position and 2rd result must be written the bottom.

      • djadhav's avatar
        djadhav
        Regular Contributor
        10 years ago

        I agree, that's what would happen. We need to use it this way

         

        rowCount = 1

         

         - Begin writing to excel

         

        Get value of rowCount

        Write to excel

        increment value of rowCount

         

        - End writing to Excel

        Loop from - Begin to - End as many times as required

         

        If you post some of your code then it'll be easier.