Pasting the specific column data to other excel file

[Priyesh_Shetty]

Hello community!

I have 2 excel file let say A.xls and b.xlsx
I have extracted specific column with values from A.xls file using this code filteredAFile=dt_A.defaultview.ToTable(False,“My Specific Column Name”)

Know when iam using excel activity like for each row and add data row it is taking a long time to paste let say it is taking 5 to 6 min
Is there any linq method to paste my extracted column to b.xlsx file under a column name which is named PO Description.

[Anil_G (Anil Gorthi)]

@Priyesh_Shetty

Linq is to work on datatable but not to write data to excel or any other external file

instead of using loop to add data …if you already knwo the order and data then use write range with the first cell where you want to start writing data…and if you dont want other columns to get effected then use a single column datatable and add the data

cheers

[Eric_Alvarado]

Hi @Priyesh_Shetty sharing this link RPA |UiPath — LINQ / Lambda Expressions and Shortcuts | by Eric Alvarado | Oct, 2024 | Medium
There is a section called ’ Write Range, specific columns’
Any of those lines work in the Write Range activity

[lakshmi.mp]

Hi @Priyesh_Shetty ,
Try using Filter data table activity.

1. Using read range activity, read data from excel.
2. Use Filter data table activity. In the Filter Wizard

• Do not specify anything in Filter Rows tab.
• In output columns tab, Mark column selection mode to “Keep” and Under columns, add the columns that you want in your output datatable.
  
  

3. Use write range activity to write the data in new excel/sheet.