Hi, I am trying to find a way to filter an excel sheet with over ten thousand rows. I tried a ‘For Each’ initially, but it was very time consuming. I am trying to filter the excel sheet and write a value in a “Status” column for the current rows displayed in the filtered sheet. I need to keep all …

Hi @NIVED_NAMBIAR Please see attachment as a reference. Each person name Charles and Michael, should have the color “Red” assigned under column B (Color). Every cell highlighted yellow in this case should have the word “Red”. [example_excel] I showed a picture how I was able to do this in Studi…

Hi @carlos_avila check this workflow text_file.zip (1.4 MB) Hope it helps you Regards Nived N Happy Automation

Hi, Please ignore anything about color. I was highlighting for the purpose to show the example of the cells that will need to be updated with the word “Red”. I tried an if in my for each activity initially but with over Ten thousand rows, it is taking a long time to execute because going through e…

@carlos_avila you can try the below code in “Invoke Code " Activity by modifying it with your required conditions dataTable.Select(”[Status]=‘YELLOW’ ").ToList().ForEach(Sub(row) row(“Status”)=“RED”)

Hi, How would I go about this with if Name = Charles or Michael, the write to Cell the word “Red” under “Color” column. Thank you.

Hi @carlos_avila , please try with the below code dataTable.Select(”[Status]=‘YELLOW’ AND( [name]=‘Charles’ OR [name]=‘Michael’)").ToList().ForEach(Sub(row) row(“Status”)=“RED”)

Hi , I want to filter column based on value and highlight the only cell from that column. Eg if Column A has 5000 rows and suppose there is value “3” or “4” in particular cell so need to highlight only those cells from column A not whole row but only cell which contains “3” or “4” value. Is there…

Filter Excel Sheet and Write Cell Based on Filter

Help Studio

NIVED_NAMBIAR (NIVED N) December 31, 2020, 5:33am 2

Hi @carlos_avila

Can u show ur requirements by providing a screenshot of what u need at output

Topic		Replies	Views
Excel: Filter and write cell Studio studio , question , activities_panel	3	1301	June 24, 2022
Write cell based on Filtered rows StudioX excel , studiox , question	2	1980	August 7, 2020
Filter and highlighting cell in Excel using vb code Activities excel	4	1011	July 12, 2023
USING STUDIO X, HOW TO FILTER THEN COPY StudioX studiox , question	8	541	July 24, 2023
How can I write text in Excel in a filtered range/cell with UIPath? StudioX studiox , question	5	1893	October 7, 2021

Filter Excel Sheet and Write Cell Based on Filter

Related topics