. NET Creating Excel Files

Question

Hi,

In my application, I need to generate excel files on the fly. I have an option of using Excel library. But it is mandatory to have excel installed on the machine.

Is there any other .NET API to generate excel files at runtime which doesn't require excel.

Thanks, Mahesh

Answer 1

Did you search on SO for this?

First one i found

Create Excel (.XLS and .XLSX) file from C#

Answer 2

If you just need a file that will open in Excel and is just data, you can output to a .csv file. These usually open in the default spreadsheet program (aka Excel on windows). They are much simpler to generate.

Answer 3

You can try SmartXLS for .net.

It is a high performance .NET excel component which can write, read, calculate Excel compatible files without the need for Microsoft Excel on either the developer or client machines.

It was entirely written in 100% managed C# code.

Answer 4

SpreadsheetGear for .NET will let you create Excel files in .NET without having Excel installed.

You can see live samples here and download the free trial here if you want to try it yourself.

Disclaimer: I own SpreadsheetGear LLC