English 中文(简体)
未安装Excel服务器的Excel文档生成
原标题:Excel file generation on server without Excel installed

我使用<代码>Microsoft.Office.Interop.Excel,并使用<代码>SaveAs方法生成Excel文档。 这一切都是在安装Excel的电脑上进行的。 然而,我的服务器没有安装Excel。

我怎么能提出我的档案?

问题回答

如果你生成一个文件,使用Interop,你需要在服务器上安装Excel。

Microsoft doesn t support installing Excel (or Word) on the server. Instead you should download the Office Open XML SDK from Microsoft and use that library to generate Excel 2007 documents. This library does not require Excel to be installed on the server: http://msdn.microsoft.com/en-us/office/ee441239.aspx

If you are talking about Excel prior to MS Office 2010, there is no set of "client libraries" that can be used to create Office documents.
"Interop" assemblies are just .net wrappers around Microsoft s unmanaged code, that make the Excel API available to .net clients.
You will have to install MSOffice on the server.

EDIT:一个类似的问题: Excel dll for Morgan.Office.Interop.Excel

如果能够向第三方图书馆提供,Spreadsheetgear是一项良好的投资。

d 建议FileHelpers 图书馆阅读和书写Excel(及其他)文档。

“文件管理员是自由和容易使用的。 NET 图书馆从固定长度或档案、档案或溪流的有限记录中进口/出口数据

这对我来说是好事,给它一个尝试。

如果你拿到新的开放式办公室Xml格式(xlsx)的话,我将非常建议看一下免费的网络图书馆EP Plus。 它易于使用,而且具有一定的特点。

如果你只需要档案中的数据,不需要图表等,那么我就只能采用XML或CSV格式。 这两种模式都是开放式的,不需要双管齐下。





相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

How to Add script codes before the </body> tag ASP.NET

Heres the problem, In Masterpage, the google analytics code were pasted before the end of body tag. In ASPX page, I need to generate a script (google addItem tracker) using codebehind ClientScript ...

Transaction handling with TransactionScope

I am implementing Transaction using TransactionScope with the help this MSDN article http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx I just want to confirm that is ...

System.Web.Mvc.Controller Initialize

i have the following base controller... public class BaseController : Controller { protected override void Initialize(System.Web.Routing.RequestContext requestContext) { if (...

Microsoft.Contracts namespace

For what it is necessary Microsoft.Contracts namespace in asp.net? I mean, in what cases I could write using Microsoft.Contracts;?

Separator line in ASP.NET

I d like to add a simple separator line in an aspx web form. Does anyone know how? It sounds easy enough, but still I can t manage to find how to do it.. 10x!

热门标签