Click here to Skip to main content
12,950,090 members (46,046 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
Hi everybody!

Please advise me some easy-to-use library to work with Excel in .NET. What I need to do:

1. Create workbook with multiple sheets.
2. Fill it with data.

Don't want to use standard built-in COM library to write lousy code like:

Excel.Workbook wb = 
    ThisApplication.Workbooks.OpenText("C:\\Test.txt", 
    Type.Missing, 3, Excel.XlTextParsingType.xlDelimited, 
    Excel.XlTextQualifier.xlTextQualifierDoubleQuote, 
    Type.Missing, Type.Missing, Type.Missing, True, 
    Type.Missing, Type.Missing, Type.Missing, 
    Type.Missing, Type.Missing, Type.Missing, 
    Type.Missing, Type.Missing, Type.Missing);


LINQ to Excel just retreives data and allows to perform queries.

Thanks in advance.
Posted 28-Mar-11 6:53am
Comments
Mark Nischalke 28-Mar-11 13:18pm
   
What version(s) of Excel are you supporting? The "lousy" COM code may be all you have.
Pavel Yermalovich 28-Mar-11 13:37pm
   
It doesn't matter. I need generate at least some Excel version's file. I meant some wrapper for COM. I found different libraries but they generally suports queries but not creating.
digital man 28-Mar-11 14:00pm
   
I think you need to search here and on Google and I'm pretty sure you'll find what you need.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Hi,

i found this one very useful since it does not require to have Excel installed:
http://code.google.com/p/excellibrary/[^]
  Permalink  
Comments
Pavel Yermalovich 28-Mar-11 15:13pm
   
This is what I'm looking for. Thanks.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Excel interop is one of the few places where I'd recommend VB.NET over C# purely because of VB.NET's ability to call method signatures with optional parameters. If you're more comfortable in C#, you can just create a class library in VB to wrap the functionality you want to use and import the library into your C# project.

That being said, there's also this: Excel Reader[^]
  Permalink  

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,749
CHill60 3,380
Maciej Los 2,953
Jochen Arndt 1,935
ppolymorphe 1,820


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100