My Requirement is an excel template uploaded in our web application(MVC,Angular1,Sql) ,the user can download it and filled all the required data(need both DB and front end validation).
Once the data is validated when then click on process button,the data will append it in to an xml template in our root directory.
Later if they want to edit the excel file,they will have to download their corresponding excel sheet and repeat the above process again.
Sorry I have limited knowledge in VSTO and Web-addins.
In our project, editing in grid using angular is already in place but this is only once the upload process is completed. But I want to validate and edit the excel directly via web application.
can we use VSTO or Web-addins instead of editing the contents in the grid?
Or any other method which is better to apt for this requirement?
Regards,
Soumya raj
What I have tried:
Create a Web Add-ins for excel but understanding and editing the coding is somewhat difficult!
Submit an article or tip