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
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
December 9, 2019, 2:23pm
There is simple way to achieve this
Read the Input file and MasterFile and you Got result as InputdataTable,MasterdataTable
Loop the InputdataTable , and inside loop you can check the MasterdataTable With Customer Id then Update the appropriate Row.
@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
@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.
You do not have to open Excel. That will do in the back end only
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)
@md.ahtesham - Share me a sample excel please. Will get it done.
InputExcel.xlsx (8.6 KB) Hi @md.ahtesham - Please see the attached sample
UpdateAnnualLimitFile.xaml (46.6 KB)
MasterExcel.xlsx (8.6 KB)
Thanks for your help, got to learn new thing today…
@md.ahtesham - Is that working fine as you expected?