0

Has to be free. Has to support all versions of Excel files. Has to have C# .NET API.

I need to do all of the specified actions (reading/creating/updating).

Has anyone used any library l this kind sucessfully

Update:

I read a lot of bad things about Ole DB, and Interop is not an option since this is a web application running on a server.

michaelr524
  • 871
  • 2
  • 11
  • 21
  • I have used this for creating, updating: http://www.carlosag.net/Tools/ExcelXmlWriter/ I'm not sure if it supports all versions of Excel. It certainly supports 2003 and 2007. – jangeador Oct 21 '10 at 14:58

3 Answers3

2

Try to use OleDB Reading Excel files from C#

Community
  • 1
  • 1
as-cii
  • 12,819
  • 4
  • 41
  • 43
1

From a previous answer on a different question:

  • You might consider using the Excel object model and COM interop to read the data from the Excel file into your application. Granted, this includes a dependency on Excel being installed, but it is a possibility. This article has some great code for getting started with reading Excel files in this way.
  • A better way might be to use a library that doesn't have a dependency on Excel being installed on the local system. This answer suggests using the Excel Data Reader library, available on CodePlex.

Like I pointed out in my other answer, there are paid third-party libraries that will likely do exactly what you are looking for. I understand you want something that is free, but in my experience with free Excel libraries, you tend to need to do a good bit of extra work to get it to play the right way.

Community
  • 1
  • 1
Ben McCormack
  • 32,086
  • 48
  • 148
  • 223
1

I'm a big fan of Aspose Cells. It does all you want but it isn't free. I don't know any other products that can fit all your needs (All Excel Versions, C# Api, Read/Write, etc)

gsharp
  • 27,557
  • 22
  • 88
  • 134