Hello Everyone, I want to extract 5 columns from below image ( costumer name,case id, match type etc) and paste in other sheet so like this multiple excel files are there [IMG20231005171616] Thanks

Look out the Image for your reference [image]

@Gokul001 I tried but it’s taking all data Thanks

It will take all the records from the specific column as you metioned @suraj_gaikwad

@Gokul001 I want only specific columns from that table with data but it’s taking all columns

Hi @suraj_gaikwad Can you share the Scteenshot of the activity? Regards Gokul

HI @suraj_gaikwad Check out the XAML file 06.10.2023_Forum.xaml (8.1 KB) [image] Regards Gokul

[image] Gokul001: Check out the XAML file 06.10.2023_Forum.xaml (8.1 KB) Check this XAML file

you can try this it will work In a data table i have 4 columns but i need only the two columns that are Names and ph try this syntax it will work dtInput.DefaultView.ToTable(false,"Names","ph") for reference you can see the output input : - [image] output: - [image] @suraj_gaikwad

[image] suraj_gaikwad: [IMG20231006115426] IMG202310061154261920×1440 318 KB Hi @suraj_gaikwad , Could you maybe check the Datatable value in the Debug Panel, if indeed the Column Names are the ones that was present in the Excel ? We have some doubts on whether the Range of the Excel shee…

@Gokul001 @supermanPunch @Praveen_Mudhiraj Column name start from row 6 Thanks

How to get specific multiplecolumns name with data

Help Activities

suraj_gaikwad (suraj gaikwad) October 6, 2023, 6:25am 10

Thanks

Topic		Replies	Views
Extract specific columns from excel Help excel	4	2590	October 18, 2019
Read specific columns from excel by column name Activities excel , activities , question	5	2883	March 25, 2023
How to get data table with selected columns from excel sheet Help excel , activities	19	15998	October 29, 2018
Extract table using Filter data table Automation Starter	11	1930	September 21, 2022
Extract specific columns and values Activities excel , uiautomation , activities , question	10	6414	March 16, 2021

How to get specific multiplecolumns name with data

Related topics