Import Password Protected ExcelData into SQL using angular 4
$10-30 USD
Đã đóng
Đã đăng vào khoảng 6 năm trước
$10-30 USD
Thanh toán khi bàn giao
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.
Hi, It's not a really big deal, but it could take some time to chose the better library to open your excel and to store the date. I think It could take a day or two, but I asked for 5 days to have time to be sure everything is like what you need.