Excel Package to export to excel in C#

Question

0.00/5 (No votes)

See more:

C#3.0

C#

Hi does any body can help in export to excel in c# using excel package

Posted 9-Jun-11 3:11am

vgsl

Add a Solution

Comments

HansRios 18-Aug-17 3:28am

Wayne suggested using microsoft excel's office interop in c# which I don't believe to be a better choice. I mean if you think about it, with it you're actually running the MS Excel application itself in order to process your files and that is quite an overhead...
Instead I would go with this approach for exporting to Excel with C#.

2 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)

Wayne Gaylard · Answer 1 · 2011-06-09T03:33:00

You don't really need a package. You can just use the Microsoft Interop Assemblies from Microsoft.Office.Interop.Excel[^], or if you know that Excel will not be installed on the client machine, you should use ADO.Net, of which you can find an excellent tutorial here How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook [^]. That tutorial is in VB, but I'm sure you can do the work around.

Hope this helps

thatraja · Answer 2 · 2011-06-09T19:11:00

Solution 2

The home page for the Excel package here ... ExcelPackage: Office Open XML Format file creation[^]

The site contains many useful links, see here[^]

Here one link from the above link
Server-Side Creation of Excel 2007 Files Using .NET 3.0 and Office Open XML[^]

Posted 9-Jun-11 19:11pm

thatraja