Copy specific Rows in Excel

Help
1

Hi All,

I need to copy the Specific rows (Based on Name) from a spreadsheet and paste in other Excel.

Ex: In Excel its having 100 rows with 10 Provider names. Each provider has 10 to 15 Rows.

image
image980Ă—220 10.3 KB

Appreciate your help! Thanks.

2

There are two options

(a) Read the excel, loop thru and based on criteria write the rows to another excel
OR
(b) Open the excel, use filter option and copy paste

3

Hi @anon96676723

1.Use read range activity to store your values in the datatable
2.Use for each row , inside that use if condition
row(“License”).ToString.contains(“STWA-”)
3.If the condition is true , then use assign activity or use write range to store your values.

:slight_smile:

4

@anon96676723 You can go step by step

  1. Build one DtataTable using Build DataTable activity.
  2. Using read range read the excel file and store the data into DataTable
  3. Use For Each Row and loop it with extracted DataTable
  4. Check whether row(“License”).equal(YourExpectedValue) using If activity
    if True : Add to another DT [ Created DT 0 point ]
    if False Leave it Blank
  5. Once the loop will over By using Write Range activity write the DT into output Excel Sheet.
1 Like
5

Hi ,

This will help you to copy the specific rows.

Regards
Balamurugan.S