Issue with append range activity in StudioX

Help StudioX
,
1

Hello! My robot works as follows:

  1. Download to sheet 1 in Excel table using Extract to datatable activity.
  2. Download to sheet 2 in Excel another table using the Extract to datatable activity.
  3. Using the append range, the robot pastes sheet 2 to the data in sheet 1, but instead of pasting the data from sheet 2 in the first empty row, e.g. 50, the robot pastes it in row 120 leaving 70 empty rows.
    Do you have any ideas about this? I’m working in StudioX and just learning, so please give me details. Thank You :slight_smile:
2

@sullivanne,

If there is some formatting in the data, bot will consider first row after the formatting.
For first run manually delete all the empty rows at the bottom and run the bot. This should work.

3

@sullivanne

When you say download what do you mean?

is it getting downloaded from some site?

are the rows having a table format or some color and all?

cheers