Excel / ASP MVC 3 Website Intergration
Posted on 2016-08-30
I would like to integrate Excel into my ASP MVC 3 website. I want my users to be able to click a link that opens an excel file template within the browser, allow them to make changes, then when they have made their changes, pass it along to my controller to save the file on the local server.
I have done some research online, but I have not found anything that will do this. The closest I have found is Microsoft's excel online viewer. However all I can do with this viewer is view the file and download it to the local computer, but not edit and upload to the website. This would require the end user to download the file, open it in Excel (assuming they have excel installed locally), then save it and upload the modified document. This is too many steps.
The other option I found was OneDrive, but this also sounds like it would require too many steps for the end user. If none of these options are realistic I may end up just creating an online form and loading the data into a SQL database.
Any advice would be appropriated!
Thanks in advance!