Mapping two excel and then updating

Help
, , ,
1

Hi,

Sorry for asking so silly/small query.
I have two excel -1 Input Excel and Other master Excel.

Based on the Input Excel Value i need to update Master Excel.
I tried two approach but it didn’t work properly.

Please have a look on both excel
Input Excel

image
image1080×362 11.7 KB

Master Excel

image
image981×576 11.8 KB

Based on this SP Customer Number i need to update Master File.
Note- Input Excel may contain null value in audited and Non-audited Column

-Ahtesham

2

Hi @md.ahtesham,
There is simple way to achieve this

  1. Read the Input file and MasterFile and you Got result as InputdataTable,MasterdataTable
  2. Loop the InputdataTable , and inside loop you can check the MasterdataTable With Customer Id then Update the appropriate Row.
3

Hi @md.ahtesham - Read both Master and Input Excel, store it DT. Do a For Each Row for Input Excel and inside that do a For Each for Master sheet.

Inside that Master Sheet DT put a if condition - InputDTRow(“SP Customer Number”) = MasterDTRow(“SP Customer Number”), if it matches then use Read Range or Read Cell by “B”(Counter) and “C”(Counter).

Then the same way perform Write Cell by “B”(Counter) and “C”(Counter)

Note:- Counter you need to increase for each row for Index purpose to map the appropriate cell

Thanks,
AK

4

@AnandKumar26, @prakaz25 ,

Is there any other way, other than Write cell activity.
i don’t want to open Master Excel (huge file already )again and again for writing value.

Ahtesham

5

You do not have to open Excel. That will do in the back end only

6

@ClaytonM,

i tried your approach to update the Excel File but i am not getting correct result.
It is updating file but result is coming very very wired.
Please have a look on my .xaml file and suggest me where i am doing wrong.

UpdateAnnualLimitFile.xaml (34.4 KB)

Ahtesham

7

Hi @md.ahtesham - Share me a sample excel please. Will get it done.

Thanks,
AK

8

InputExcel.xlsx (8.6 KB) Hi @md.ahtesham - Please see the attached sample

UpdateAnnualLimitFile.xaml (46.6 KB)

MasterExcel.xlsx (8.6 KB)

Thanks,
AK

9

Thanks for your help, got to learn new thing today…

Thanks,
Ahtesham

1 Like
10

Hi @md.ahtesham - Is that working fine as you expected?

Regards,
AK