Hi All, I am stucked in one problem. Example- col1 col2 col3 data1 data2 data3 data4 data5 data6 data7 data8 data9 Suppose data5 have value arquivo. I have to extract whole row data which has value arquivo from excel and put in other excel How to proceed? Can anyone please help.

@farheenfatma61 You need all Fil1 files names to filter? [image] Thanks

@Srini84 my query heere is that if last line of Fil1 contain Successo in column(document) then i have to extract all the row which has Fil1in column(files name)

@farheenfatma61 Check attached Output.zip (8.7 KB) Hope this helps you Thanks

@Srini84 Thank you. But it worked for only 1 file but i have multiple files in input excel sheet which i have to filter in other sheet. How to do that can u please explain?

@Srini84 i have multiple files like Fil1, Fil2, Fil5 etc and have to extract all those in excel file. can u please explain how to do that?

@farheenfatma61 in general we can adress the case with a filter / filter approach: [grafik] first filtering to all rows with document = Sucesso iterate over the first filterresult and do filtering to the corresponding files name merge the part filterresult to finalFilterResult Find demo XAM…

@ppr Thank you. One more query if i want extract the rest data from “Book1.xlsx” which does not come in output. How to do that? Can u plz explain.

@farheenfatma61 have a look here: farheenfatma61_V2.0.xaml (15.1 KB) Please let us know if it is working by closing the topic with the solution mark. Thanks. For open questions we are here to help

@ppr Showing error Error is - ‘AsEnumerable’ is not a member of ‘System.Data.DataTable’

have a look here for fixing [image] AsEnumerable is not a member of 'System.Data.Datatable' Help Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open…

Extract specific column data from excel file

Learning Hub Academic Alliance

ppr (Peter Preuss) October 8, 2020, 1:48pm 23

have a look here for fixing

Topic		Replies	Views
How extract important data from excel cell Studio studio , question , project_panel	12	482	November 21, 2023
Extract value from DataTable when condition is satisfied Help	20	5369	May 18, 2018
Extracting specific excel column data Help datatable , activities , question , data_manipulation	7	2804	December 30, 2019
Extract specific data in Excel spreadsheet Help datatable , excel , activities , question , portuguese	1	1597	July 9, 2020
Extract excel data Help studio	9	1700	July 29, 2019

Extract specific column data from excel file

Related topics