Commercial Collector / .NET CSV Library

Question

Our company has largely banned us from using open source libraries in our commercial products due to licensing issues. We are currently looking for a commercial .NET library that can read and parse CSV files - does anyone have any ideas?

In terms of functionality, I really need to be able to read a CSV file in a strongly typed DataTable - with appropriate conversion and tagging type conversion errors.

thanks

Matt

Answer 1

CSVReader did the trick for us.

Answer 2

.NET has a built-in CSV parser. The real one that follows the RFC for writing and provides error recovery when some lines are bad, but the rest of the file can be parsed.

http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.fileio.textfieldparser.aspx

Answer 3

I think it would be nice to explore the differences between the different open source licenses so that you can explain who "forbids" you to use them, what they all mean and what are the consequences for your company.

For example, I would never protect the GPL library in one of our closed source programs, but L-GPL'ed could be made to work. Other licenses are also less burdened.

Also keep in mind that just because the library is published on the Internet as a GPL, quite often, if you send an email to the author (s), you may find that they have other licensing options. For example, I was interested in one GPL library, sent an e-mail to the author, and he said that he would be happy to receive licenses for closed-source projects for $ 100 a year for support and without cost of execution time (which is only $ 100 for everyone, who in our company uses the library on any number of products that we ship).

This damn sight is better than $ 3000 for the development version and $ 500 for the execution time for the commercial library, which I also considered. Admittedly, the commercial library has done much more than the open source library, but at that time we did not need all these additional features.

Answer 4

FileHelpers v 2.0

Answer 5

The excellent Sébastien Lorion CSV library is licensed under the MIT license , so you can do almost anything with it while you confirm the original copyright.

Answer 6

How about using embedded OleDb in .NET with Jet Engine. It also handles various types of file delimiters. See Article

http://www.codeproject.com/KB/cs/UsingJetForImport.aspx

Answer 7

Try the CSV Helper (which I wrote). It is licensed by Ms-PL. If you can use Microsoft products, you can also use this.