Hi Everyone, I’m facing an issue with filtering my excel data. I have a excel with 5000+ data every day data will be increasing but the difference is date. Every day data will be increasing with current day date. Now my scenario is i want to get only yesterday date data. I’m trying to do it with L…

Hi @Learner007 As per the query it will return the Null value When there is no matched rows are selected, So you can not find the count. If you want to find the count add IF Activity with " Dt is Nothing" Condition, So if there is no matched rows are selected that means the Condition will return th…

Just use the Filter Datatable activity to get the rows you want.

Hi @postwick getting error with that. I’m unable to filter. I think i’m missing something which i’m unable to solve that. As i have 1st row empty and i should not delete that.

Post screenshots showing how you have the Filter Datatable activity set up. Why do you need a blank first row?

[image] ambulance sos [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues Tutorials This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in a hurry:…

@postwick The excel i should not change anything. I need to keep it as actual. I just need to pick the data and filter. If i use row index for Filterdatatable activity it is giving me Null. If i use column name it is giving Column name is not set or is invalid

Then you’re not configuring it correctly. Post a screenshot. We can’t help you if you don’t show us what you’re doing.

@Learner007 If you writeline you dates you may see your problem maybe, when you read your excel, the date format is 05/23/2023 00:00:00 You can Read Range the Excel without headers Filter Data Table using Column index 2 = Today.AddDays(-1) Write Range Filtered Data Table Regards

[image] michael.zura: You can Read Range the Excel without headers Filter Data Table using Column index 2 = Today.AddDays(-1) Hi @michael.zura if use this code it is working but here i’m filtering with row index but in future if they change the row it will cause an issue right. Is there any …

Hi @ppr . I tried to modify and apply this. I’m unable to make it working as per my requirement. Can you please help me on this. I have attached my Code in above message.

Can anyone help me on this. Any leads how to solve this Using LINQ. I’m able to filter this when i don’t get first row empty. But here my challenge is i should not delete that first empty row. Excel_Filter.zip (160.6 KB) This code is working fine for data without having empty row. But i need it ev…

Need to filter Excel Data based on Date

Help Activities

ppr (Peter Preuss) May 24, 2023, 5:24pm 5

Topic		Replies	Views
Filter Datatable rows on yesterday's date - large excel Studio excel , activities	22	3096	October 2, 2020
Can Someone help me with filtering excel column which has a date Studio uiautomation	9	1161	March 28, 2022
Need to filter out date column in excel file Studio studio , question , activities_panel	11	477	October 26, 2023
Condition to filter date from excel Studio activities , studio	20	1923	July 11, 2022
Filtering the date Activities database , activities , question	10	1513	August 10, 2021

Need to filter Excel Data based on Date

Related topics