Add One Excel Data To another Excel

[Yoichi]

HI,

Can you try the following?

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

Book2.xlsx will be updated.

Regards,

[vineelag (vineetha)]

HI @Yoichi

all are Good But Its not adding Data in Quantity Column

Thank You!!!

[Yoichi]

Because they are not same column name.

If you need to merge them, please modify “Quantitiy” to “Quantity (Hours)” in Book1 in advance using Write Cell activity etc.

Regards,

[vineelag (vineetha)]

Thank You So Much @Yoichi Your The Best

[vineelag (vineetha)]

Hi @Yoichi

i try to understand but unable to, would you please let me know what we are doing here for below steps

Thank you!!!

[Yoichi]

Hi,

Your datatable has 2 “code” column. And it causes error to read table as DataTable using ReadRange activity with add header option.
So, to avoid this matter, first read table without header, then set column name from content of the first row with checking duplicate. If there is same name column name, change column name and set it.
Finally delete the first row because it’s just header.

Regards,

[vineelag (vineetha)]

Hi @Yoichi

while running the process getting this error

its read all columns after last column its getting like this

Actually i am using excel application scope to read the data and the master file contains multiple sheets and one of the sheet i am using and remaining different sheets contains VLOOKUP and different formulas.
the second file is working fine.

Please kindly let me know.

Thank you!!!

[Yoichi]

Hi,

Can you share content of $exceptionDetail when the error occurs?

Regards,

[vineelag (vineetha)]

Hi @Yoichi

My Actual Input master Files Showing like this If I Read Column Names

So Please Kindly Help Me On THIs They Are Empty

THe AcTual File Look Like This

Thank You!!

[Yoichi]

HI,

Probably the datatable contains blank columns.

Can you try to add to check if column name is blank as the following?

Sample20231122-5Lv3.zip (40.1 KB)

Regards,