Solved

Excel / ASP MVC 3 Website Intergration

Posted on 2016-08-30
2
36 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
Comment Utility
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
Comment Utility
Thanks!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now