Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

Write list to excel to Excel - Each Item in a new Row

 Hi,


This is simple, but I cannot seem to figure it out.


I have extracted a list of emails from a website, but when I write to Excel it puts all the emails in A1, rather than each email in it's own cell.


The list on the site is populated like

Email 1

Email 2

Email 3 etc.


Can you please inform me how to write this into excel so A1 is email 1, A2 is email 2 etc.?


Thanks


Jack


Best Answer

Set Variable %RowCounter% = 1

For Each( %List_Emails% )

    Write to Excel Worksheet( Column: 1, Row: %RowCounter% )

    Increase Variable %RowCounter% by 1

End Loop


Answer

Set Variable %RowCounter% = 1

For Each( %List_Emails% )

    Write to Excel Worksheet( Column: 1, Row: %RowCounter% )

    Increase Variable %RowCounter% by 1

End Loop


2 people like this

Thanks for taking the time to reply. I knew how to do it, almost, just couldn't get my brain in gear.


Thanks for helping me out!!


2 people like this
Login or Signup to post a comment