Excel_Automation_Insert_Value

[Zaw_Win_Htun1 (Zaw Win Htun)]

Dear Experts,

I want to add “0” in OpenAmount when Document No are the same number and leave actual amount in only one row. This is the original excel file.

I want the excel like this. Adding “0” in other rows and leave actual amount in only one row when the Document No are the same.

I attached the sample excel file for reference. If you have any solution, please provide me. Many Thanks.
Book1.xlsx (8.3 KB)

[Srini84 (Srinivas)]

@Zaw_Win_Htun1

It’s something you can relate with the below usecase

Reference-1

Hope this will help you

Thanks

[Zaw_Win_Htun1 (Zaw Win Htun)]

Thanks. It takes a long time when the data record is huge.

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

If you have so many records. Don’t go with loop concept it will take huge time. You can use below steps.

1. Use excel activity to open excel by input the excel file path.

2. Read cell activity to read the C2 value and enter the value with write cell activity to D2 cell.

3. Use write cell activity to insert formula like below “=IF(C2=C1,+CHR(34)+“0”+CHR(34)+”,C2)"
   In D3 cell.

4. Use Auto fill formula to fill the formula with visible range so you will get the expected output in the D column.

5. Now use copy paste range to copy the D column data to replace with the C columndata.

6. Use delete range activity to delete the d column data.

With the above steps it will take fraction of seconds to complete the automation. Please try and let us know. Thanks.

[Zaw_Win_Htun1 (Zaw Win Htun)]

Thanks for reply. It’s working fine. It is solution.

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

Could you please mark solution if you think my post as solution for your issue. Thanks. Have a nice day.