Excel文档和ASP.NET应用程序 [英] Excel document and ASP.NET application

问题描述

应用程序构建在MVC-4，KENDO-UI，C＃中。这个应用程序所需的功能是下载excel文件编辑它并上传回来。



有什么各种选项可以达到这个目的？一个非常简单的方法是使用两个按钮，即一个下载/检索，另一个上传。



我的问题： - 有没有更好的方法来实现这一目标？我可以将excel表连接到应用程序，这样每次点击保存它都会被保存并上传回应用程序吗？



或更好的下载和上传方式。 br />


请帮帮我。

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.

推荐答案

当你使用ASP.NET时，我会建议使用Open XML SDK：如何从MS Visual Studio 2010中的添加引用添加microsoft excel 15.0对象库 [ ^ ]。



请参阅本文中引用的过去的答案：如何添加微软MS Visual Studio 2010中的添加引用中的excel 15.0对象库 [ ^ ]。



如果你想使用* .xls（不是* .xlsx），我不推荐它。旧格式不是公共标准;你需要使用一些第三方产品，比如LibreOffice库。

-SA

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

这篇关于Excel文档和ASP.NET应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！