This is to implement in an existing project, I want the user to select an excel file which will be password protected, which they need to provide. Once the user provided the password an hit upload then the file gets uploaded into SQL database. also, need a popup box to notify user 1) data uploaded(how many rows processed ) 2) data validation(if the int column has a string in it the popup should display there is a validation error in line(n) please fix it)
frontend: HTML for "chose file" + password Textbox + upload Button.
[login to view URL]: contains onsubmit function in angular 4(some type of http post)
[login to view URL]: contranins data validation and entity FW to insert data
[login to view URL]
this is somting I did but its not working as its supposed to.