I’m trying to select an excel column based on a string. However, that string is not at the top of the file so the “column name” function didn’t work. Please let me know how I should approach this. I want to pull the entire column following a particular string.

Select Column Based on String

balupad14 (Balamurugan) July 18, 2020, 8:45am 4

Welcome to UiPath Community !

Here is an activity called “Find”. It will return the cell info and row index. based on the cell info you can select the column.

Video :

Thank you
Balamurugan.S

Topic		Replies	Views
Select Multiple Columns Based on Strings Help	0	782	July 22, 2020
Select Cells in Excel Based on Cell Value Help	16	7625	March 10, 2018
Excel automation 2 Something Else feedback	15	593	October 7, 2022
How to iterate through columns Help excel , uiautomation , studio	25	12572	March 4, 2019
Select Columns in Excel sheet Help	14	7786	November 13, 2018