Solved

Excel / ASP MVC 3 Website Intergration

Posted on 2016-08-30
2
48 Views
Last Modified: 2016-09-06
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!
0
Comment
Question by:filtrationproducts
2 Comments
 
LVL 30

Accepted Solution

by:
MlandaT earned 500 total points
ID: 41776753
You've answered your question already :). You don't have many options. Either build your own form and maybe use of the many excel like table editing scripts (http://jspreadsheets.com) OR let the user download and open the file using Excel in their computer. Many PC users will have Excel or make use of LibreOffice
0
 
LVL 1

Author Closing Comment

by:filtrationproducts
ID: 41786314
Thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
hbo knew my windows software 4 62
JSON  parse help 7 40
Changes to XXX.exe.config file are not retrieved on restart. 3 39
MYSQL responding very slow 3 21
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question