Click here to Skip to main content
15,867,330 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Application is build in MVC-4,KENDO-UI,C#. Functionality required from this app is to download excel-file edit it and upload it back.

What are various options do I have to achieve this? One very simple way of doing it with two button i.e. one to download/retrieve and another to upload.

My question:- Is there any better way to achieve this? Can I hook excel sheet to app so that every time I click on save it will be saved and uploaded back to application?

or better way to download and upload.

Please help me.
Posted

1 solution

As you are using ASP.NET, I would advise to use Open XML SDK: How to add microsoft excel 15.0 object library from Add Reference in MS Visual Studio 2010[^].

Please see my past answers referenced in this one: How to add microsoft excel 15.0 object library from Add Reference in MS Visual Studio 2010[^].

If you want to use *.xls (not *.xlsx), I would not recommend it. The old format is not a public standard; you would need to use some 3rd-party products, such as LibreOffice library.

—SA
 
Share this answer
 
Comments
sushil_gupta 7-Oct-14 12:21pm    
I want to go for .xlsx but you didn't answer the question.
Sergey Alexandrovich Kryukov 7-Oct-14 12:40pm    
If you do it with .xlsx, it's good. Better go for Open XML SDK.
The answer is in my referenced answers. If you need something else, please clarify.
—SA
sushil_gupta 7-Oct-14 14:51pm    
Thanks for your answer...But the question i was asking Is there is a way to hook .xlsx document to asp.net? (Means if i click save automatically document get saved and uploaded back to asp.net app). Other question was is there any better way to download and upload .xlsx document (One way i know is on click of a button download it).
Sergey Alexandrovich Kryukov 7-Oct-14 15:02pm    
Oh... There is not a way to "hook" it, just because Open XML, Office are not part of W3 standards. All you can do it to map the Office document to HTML in one or another way, and show only HTML.
—SA
Sergey Alexandrovich Kryukov 7-Oct-14 15:02pm    
Do you need to allow the user to edit the documents? This is solvable, too...
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900