In the excel file, I have data like vendor name & Total … I have to read the excel file & Update the total value in the web application. Once it is done. In excel It has to create a new column i.e in C column it should create a status as a header and based on the vendor which the payment is updated in a web application the status should set to Success…
Reading the excel & updating to a web application is done. How to create column & update the status
Example - If Airpower amount is entered in web application then in C3 cell it should written as Success.
Any suggestion for this, Thanks in advance.