Export to Exel without Using Microsoft.Excel lib?

Question

0.00/5 (No votes)

See more:

I Just want to Convert the Database table with large data into the Excel sheet in my C#.Net Windows application but not using the Microsoft.excel;(must be freeware & platform independent) so is any another way by using some open excel or anything???
Any type of help would be appreciate as I need it very much..I will wait, just share your knowledge to check yourself!!!
Thanks in advance,

Posted 7-Oct-12 20:42pm

Killer Coder

Add a Solution

Comments

Zoltán Zörgő 8-Oct-12 2:48am

1) It will never be "platform independent".
2) You want XLS or XLSX?
3) Do you really need native excel format, or others readable by excel can also be used?

Killer Coder 8-Oct-12 2:59am

Anyone will be ok XLS, XLSX because both will work.Need native excel format.
& why it will never be platform independent?

Zoltán Zörgő 8-Oct-12 3:06am

Because .net is not platform independent. Actually it depend on what you mean under "platform independence". See my answer down there.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Santhosh Kumar Jayaraman · Answer 1 · 2012-10-07T20:52:00

Solution 1

You can use openxml SDK

Check this article.
Export GridView Data to Excel using OpenXml[^]

Posted 7-Oct-12 20:52pm

Santhosh Kumar Jayaraman

**Zoltán Zörgő** · Answer 2 · 2012-10-07T20:57:00

There are libraries out there that can help you. Not all have the same functionality covered, and not all have the same licensing.
- This one could be used for the old (xls) format: http://code.google.com/p/excellibrary/[^]
- Here you can read an article about how to write an xlsx on your own: How to Read and Write .xlsx (Excel 2007) file - Part I[^]
- You can trick Excel easily by creating a proper html file and saving it with xls extension. Will work like a charm :).
- Excel has ODS support: How to Read and Write ODF/ODS Files (OpenDocument Spreadsheets)[^]
- And there are other component out there you might find interesting, like this one: http://npoi.codeplex.com/[^]

Miracle524 · Answer 3 · 2012-10-07T21:05:00

Solution 3

You can use this free dataexport component [^] to export database table to excel, please see below article in detail:
9 Solutions to Export Data to Excel for ASP.NET[^]
Export Data to Excel, Word, PDF without Automation from DataBase[^]
How to export customized format data to Excel[^]

Posted 7-Oct-12 21:05pm

Miracle524

Comments

Killer Coder 8-Oct-12 5:27am

I don't think it will be acceptable by my client because though its free component to use but Support is payable.
but anyway thanks Miracle to give me an alternate way.

[no name] 8-Oct-12 5:50am

You can add your problem on the comment section after these article, I believe someone will help you.give it a try.