-3

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,

Improve this question
4
  • 2
    This "question" has been asked 100000000 times! Commented Apr 15, 2013 at 19:22
  • I don't know if it's "the best" but I've used epplus.codeplex.com with success. Commented Apr 15, 2013 at 19:23
  • 1
    Look at the "Related" posts here to the right >> Commented Apr 15, 2013 at 19:23
  • I used the OpenXML sdk and it worked well. Commented Apr 15, 2013 at 22:03

2 Answers 2

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

with image you mean charts?
@AngeloGabrielEscuderoVía Yes.
0

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

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.