Excel Automation

Question

I used Microsoft.Office.Interop.Excel And genarate Excel file using SaveAs method.All are work correctly in computer Which install Office excel.My server does not contain excel . How can i run .Please help

Answer 1

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: A similar question here: http://stackoverflow.com/questions/564443/excel-dll-for-microsoft-office-interop-excel

Answer 2

If you generate a file using Interop you need to install Excel on the server.

Or you could 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

Answer 3

If you can afford a third party library, Spreadsheetgear is a good investement.

Answer 4

I'd recommend FileHelpers library to read and write Excel (and others) files.

"The FileHelpers are a free and easy to use .NET library to import/export data from fixed length or delimited records in files, strings or streams."

It works well for me, give it a try.