How to put multiple data into same excel file with different sheets by sequence?

Help StudioX
, , ,
1

Dear all, I wish to perform the automation with following steps. However, starting step 5 onwards which I have highlighted below, I have no idea what resource/card to be used. Can any expert advise in this matter? Thanks in advance!

As summary, I want my bot to download multiple data from website and then put into same excel file but in different sheets by sequence.

Example:
image

  1. Bot downloads from website and saves excel file named as “backbone 1” into folder 1.
  2. Bot transfers “backbone 1” excel file into folder 2. (Now there is no “backbone 1” excel file in folder 1 anymore)
  3. Bot copy data inside “backbone 1” excel file and paste into “backbone 2” new excel file.
  4. Bot rename sheet in “backbone 2” excel file as “ONE”.
  5. Bot again downloads from website and saves excel file as “backbone 1” into folder 1 since no “backbone 1” excel file in folder 1 anymore due to item no.2.
  6. Bot insert new sheet in “backbone 2” excel file and rename as “TWO”.
  7. Bot copy data inside “backbone 1” excel file and paste into sheet “TWO” in “backbone 2” excel file.
2

Like this?

image
image451×781 24.4 KB

for the destination of the copy range use in advanced editor :
Excel2.sheet(string.Format(“Sheet{0}”, CurrentItem.ToString))

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.