generate an excel file in C#

Question

I'm developing an application on C#. This is a web application. As a part of this application, I need to generate an excel file that will be store into the DB. This mean that the user won't see/open the file on the browser. So I was thinking of using a thread that will generate the excel file and store to DB. So my question is: What is the best library for generating excel files tanking in consideration that my excel file will have data and graphics generated from the data?

PS: remeber that this process will be executed on the server side.

Thanks,

I don't know if it's "the best" but I've used http://epplus.codeplex.com/ with success. — sous2817, Apr 15 '13 at 19:23
I used the [OpenXML sdk](http://www.microsoft.com/en-us/download/details.aspx?id=5124) and it worked well. — Conrad Frix, Apr 15 '13 at 22:03

score 0 · Answer 1 · answered Apr 15 '13 at 19:23

0

I have used OpenXML (for image insertion) and ClosedXML (when we have only data and no image). ClosedXML does not support image addition into worksheet yet.

answered Apr 15 '13 at 19:23

Vishy

1,292
12
17

with image you mean charts? – Angelo Gabriel Escudero Vía Apr 15 '13 at 20:35
@AngeloGabrielEscuderoVía Yes. – Vishy Apr 16 '13 at 15:00

score 0 · Answer 2 · answered Apr 15 '13 at 20:35

0

I'd use the Excel.exe itself as reference, working directly with the Excel Interop.

answered Apr 15 '13 at 20:35

Daniel Möller

84,878
18
192
214

generate an excel file in C#

2 Answers2