How can I write data from object to excel document using C#?

Question

0.00/5 (No votes)

See more:

Sounds very stupid but...

Tried to find something usefull but so far I found only something about OleDB...

I have a list of object. In each object I have 3 string fields.

I need to write all of them into excel document (create table in excel ofcourse).
Is there an simple way to do it? (Without database and connection string)?

Posted 5-May-14 5:38am

Member 10503105

Add a Solution

2 solutions

Solution 2

You can't really write a raw excel file (xls, xlsx) without either OLE or Interoperable code and both require excel to actually be on the machine.

The files are a horrible binary format and if you want to really have a crack at raw writing them the specification is here

http://msdn.microsoft.com/en-us/library/cc313154%28v=office.14%29.aspx[^]

The alternative is to write a simple comma seperated value text file (CSV) which excel supports on it's import.

http://en.wikipedia.org/wiki/Comma-separated_values[^]

If you really need xlx,xlsx files then interoperable code is easy but it is excel version specific. OLE is a little more complicated to setup and use but it is generic to the different versions.

Posted 5-May-14 6:19am

leon de boer

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)

DamithSL · Accepted Answer · 2014-05-05T05:59:00

check below links
http://matijabozicevic.com/blog/csharp-net-development/export-data-to-excel-using-csharp[^]
C# Generic List Extensions for Data Output to Formatted String, CSV File, and Excel Worksheet Window[^]
http://stackoverflow.com/questions/1831024/help-converting-generic-listt-to-excel-spreadsheet[^]
http://stackoverflow.com/questions/1059951/export-a-c-sharp-list-of-lists-to-excel[^]