How to copy and paste with conditions

Help Activities
, ,
1

Request a sample file Or how to copy data from row 2 to the last row of Excel1 (Statement Download) without knowing which row the amount of data ends in. If row A1 doesn’t have the word “No data” but if there is, copy and paste it into Excel2. that is month data (Original) without overlapping the original data.

2

I could find two different questions
Can u elaborate a little bit more clearly
@Sarttra

3

Can you share the sample data

@Sarttra

5

Original.xlsx (10.0 KB)
Statement Download.xlsx (9.7 KB)
@Praveen_Mudhiraj @Palaniyappan

6

If your expecting this as output you can try this xaml

@Sarttra

1 Like
7

@Sarttra

Following are the steps to follow

  1. Use read cell activity with A1 as the cell
  2. Use if condition to check the output of step 1 is No data or not using str.Equals("No Data")
  3. On the else side use read range with range as A2, this will read all the data till the end
  4. Use append range activity to append the data to already existing file

Hope this helps

Cheers

8

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