Hi, I have a scenario like below and need help, [image] I need to get the range of Plant codes as a datatable based on the Company Code. The company code is my input. How can I get the plant codes as a datatable for the Company Code? For example: If the company code is 4000, The Plant code I need…

Hi @esakki1612 , Could you give this workflow a try and let us know if it works out for you? [image] [image] //To find row which contains code dt.AsEnumerable().ToList().FindIndex(Function (x) x("Company Codes").toString.Equals("5000")) //Collects rows until next code dt.AsEnumerable(). Skip(i…

Excel - Get Specific Range

Help Studio

esakki1612 (Esakki1612) January 3, 2023, 8:41am 4

Thanks alot Ashwin. It Worked

Topic		Replies	Views
How to extract special data from excel sheet Studio datatable , activities , studio	8	981	December 22, 2021
Need to get data from excel sheet on specific range like first row and 17th row Help	5	4444	August 29, 2019
How to filter specific data from a datatable? Help datatable , excel	9	6245	September 23, 2019
Read Datatable and get row based on criteria Help	6	6159	February 26, 2019
How to get the specific number of rows from the datatable? Learning Hub	11	6453	April 27, 2020

Excel - Get Specific Range

Related topics