How to copy the filtered rows and paste the data in New excel file

Help Activities
, , ,
1

Hi Team,

need to filter the data exceeds 55 from column W and filtered data will be paste in to new excel file using UiPath

2

Hi @Ramudu

Use Filter DataTable activity

The image shows a Filter Wizard tool with settings configured to keep rows where the "ColumnName" value is greater than 55. (Captioned by AI)
The image shows a Filter Wizard tool with settings configured to keep rows where the "ColumnName" value is greater than 55. (Captioned by AI)772×490 17.3 KB

Regards,

3

@Ramudu

This image depicts a data processing workflow in which data is read from an Excel file, filtered through a data table, and then written into a new Excel file using UiPath activities. (Captioned by AI)
This image depicts a data processing workflow in which data is read from an Excel file, filtered through a data table, and then written into a new Excel file using UiPath activities. (Captioned by AI)482×578 18.3 KB

Regards,

4

Hie @Ramudu hope this code help you to filter you data …
your input

The image shows a "Build Data Table" activity in a workflow software, with a data table containing various numerical values under a single string column named "Column1." (Captioned by AI)
The image shows a "Build Data Table" activity in a workflow software, with a data table containing various numerical values under a single string column named "Column1." (Captioned by AI)828×384 14.7 KB

Filter data on condition basis
A programming workflow involves assigning rows from an input data table to an output data table based on a condition that values in "Column1" are greater than 55. (Captioned by AI)
Note: dtoutput is also a datatable variable
finally your output
This image shows a UiPath workflow involving activities such as Assign, For Each Row in Data Table, and Write Line, with the Output pane displaying the execution results. (Captioned by AI)
This image shows a UiPath workflow involving activities such as Assign, For Each Row in Data Table, and Write Line, with the Output pane displaying the execution results. (Captioned by AI)1347×534 34.5 KB

and if you want to include 55 also add = also
like this
The image displays a UiPath workflow execution log showing filtered data values and a LINQ query snippet used to select rows from a DataTable based on a condition. (Captioned by AI)
The image displays a UiPath workflow execution log showing filtered data values and a LINQ query snippet used to select rows from a DataTable based on a condition. (Captioned by AI)702×386 15.8 KB

then it will include 55 too

cheer Happy Automation

5

after filtering i want to paste the filtered data in to new excel file and delete the filtered data in current excel file using linq queries.

6

Pass the output of linq query to write range activity it will update the into new excel sheet.

7

For example
Input file have 50 rows
After filtering i have obly 25 rows.
So i need to add filtered 25 rows in same input sheet.

Need to delete remaining rows of data in input file. Kindly suggest with linq query.

8
  • Read Range
  • Filter Data Table
  • Write Range
9

Hey @Ramudu after filtering just use the write range activity and give the new sheet name and use delete sheet/clear sheet activity to clear the data from the filter sheet.
cheers Happy Automation

10

Hello @singh_sumit ,
I did same thing but here j have one problem.
The input file have template with different colours lo rows and columns.

If i use clear sheet activity then the colours also clearing. So i don’t want edit or change the template colours.

I want to remove the data present inthe excel sheet after filtering.
Need to be write the filtered data in a smar template kindly suggest.

11

Hi @Ramudu

Can you try the below

The image depicts a UiPath automation workflow sequence for processing Excel files, including copying data from an input Excel file to an output Excel file, applying filters, and deleting rows. (Captioned by AI)
The image depicts a UiPath automation workflow sequence for processing Excel files, including copying data from an input Excel file to an output Excel file, applying filters, and deleting rows. (Captioned by AI)818×1967 88.5 KB

A filter dialog box is shown with advanced filter options configured to filter values greater than "55" using an "And" condition. (Captioned by AI)

Regards,

1 Like