I’ve looked at similar posts regarding this but I’m still struggling to get it to work. I ultimately want to remove all rows from my “RawData” Excel worksheet where Month != “Dec”. I’m using the following flow (Read Range, Filter Data Table, Write Range). When I execute it only opens my Excel file a…

Properties of Read Range: [image]

@dumwalke Try below select Query. newDT = inputDT.Select("Month NOT LIKE 'Dec%'").CopyToDataTable And then use Write Range Activity and pass newDT to it.

So I created a new variable like this: [image]

And my write range looks like this: [image] But it still didn’t work. What am I missing?

Thank you for helping! Here is a screen shot of my Filter Data Table Wizard: [image]

And here is a screenshot of my Write Range properties: [image]

[image] dumwalke: (Read Range, Filter Data Table, Write Range). When I execute it only opens my Excel file and then Fine can i have a screenshot of your excel column with that value Dec and one more thing you want to keep the records or remove the records which are not having Dec in the co…

Sure. Here is a screenshot of the column. I want to Remove all rows where the Month is not equal to “Dec”. [image]

If your ultimate goal is to have the excel file filter, it would be easier to do it with excel macro, but if you wil work with that data inside uipath, then you will have trouble to use a DateTime column as it was a string to filter…

Remove rows from Excel sheet

Help

Palaniyappan (Palaniyappan P ) December 19, 2019, 1:25pm 6

Hi
welcome to uipath community
if possible can i have a view on the FILTER DATATABLE WIZARD with a screenshot
make sure that you have used like this
COLUMN NAME MUST BE IN DOUBLE QUOTES

Cheers @dumwalke

Topic		Replies	Views
I need to delete the row which the row contain only date Academy Feedback lp_developer_adv	16	2500	February 21, 2021
Filter excel table to remove particular rows Help datatable , activities , question	15	3751	June 13, 2024
How to remove rows from data table based on one column Studio datatable , excel , uiautomation , activities , studio , question , activities_panel	8	1092	April 20, 2023
Filtering datatable Help	7	1186	January 21, 2019
Excel remove filter data table Studio excel	10	978	August 3, 2020

Remove rows from Excel sheet

Related topics