Hi all And Excel 1 and Column names [image] I have Exce21 and column names are Given Below [image] My Requirement Add Excel 1 add/Replace Data In Excel2 Based On There Columns. How can i achieve This. Thank You!!!

HI, Which version of Studio do you use? Regards,

@Yoichi Version 2023.4.6 I have another Doubt I am Getting like this Error while reading Excel [image] Where Excel Headers Look like This [image] Thank You!!!

@Shiva_Nikhil can You Share With Me As Xaml !!!

Ok, I will create file look like your file then try it I will sent code to you regards,

Hi, How about the following sample? [image] Sample Sample20231122-5L.zip (21.2 KB) Regards,

Hi @vineelag , My input [image] my output [image] Is this expect output regards,

@Yoichi Its Working But I Don’t want Column Name(A) From Excel1 These are the Actual Files Book1.xlsx (9.4 KB) Book2.xlsx (9.7 KB) Please Kindly Let Me Know On This. Thank You!!!

Hi, Can you also share expected output as file? Regards,

Hi @Yoichi Here is the Excepted OutPut OutPut.xlsx (10.2 KB) Thank You!!!

HI @Yoichi all are Good But Its not adding Data in Quantity Column [image] Thank You!!!

Add One Excel Data To another Excel

Help Studio

Yoichi (Yoichi) November 22, 2023, 8:47am 21

HI,

Can you try the following?

Sample20231122-5L (2).zip (40.0 KB)

Book2.xlsx will be updated.

Regards,

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
Read and add data excel Studio datatable , excel , studio	6	805	September 10, 2021
I have 2 excel with same headers Studio studio , question , activities_panel	9	781	September 9, 2023
How to add specific column in different excel sheet Activities excel , activities , question	6	76	August 25, 2024
Combining excels StudioX datatable , excel , studio , data , excel-automation	3	222	February 26, 2024
Merge rows from 2 excel files but different column names Help	6	3784	January 31, 2018

Add One Excel Data To another Excel

Related topics