• Home
• About
• Blogroll
• Contact
• Links

CSV reader

CSV reader is the only which provide Read, write, and bulk load CSV files.
Read and bulk load Excel XLS spreadsheet files.
Read and bulk load XML files.

It is also available for free download.

There are two versions:-

Download:- .Net Version: datastreams.zip (http://www.csvreader.com/csv_downloads.php)

Download Free Java Full Version:- javacsv.zip

Summary:-
Csv Reader is an extremely fast and stable .Net class for stream based parsing of virtually any commonly found delimited data format, CSV files, tab delimited files, etc. It’s usable from C#, VB.Net, ASP.Net, or any other .Net language. It’s compatible with the 1.0, 1.1, and 2.0 .Net frameworks. The methods are designed for ease of use, while the inner architecture is designed purely for speed and efficiency. Parsing is done using the de facto standard CSV file specifications. It handles quoted fields, delimiters in the data, and even data that spans across multiple lines. This gives you the ability to open csv files, edit csv files, and save csv files all directly from code. Data can be parsed in less than half of the time of any other parser it has been benchmarked against. Rough benchmarks on a 2 Ghz processor, parsing common comma separated columns is 20 MB, or 390,000 rows with 5 columns each, almost 2,000,000 cells total, of data parsing per second. Virtually no garbage collection is needed from the framework because of object reuse internally while parsing. All development is thoroughly unit tested to guarantee fewer bugs and to insure proper handling of extreme cases, currently using 195 test cases and 1308 asserts across 4800 lines of test code. Pricing is extremely cheap and licensing is amazingly open. One license is good across all machines enterprise wide.
There are three versions:-

Version 4.0:

Version 4.0 adds functionality to read and bulk insert xls spreadsheet file data generated from MS Excel with the new XlsReader and XlsDataReader classes which read the spreadsheet data at the binary level using 100% managed code with NO external dependencies like Jet or having Excel installed, just the .Net framework.
Version 3.0:

Version 3.0 triples the existing functionality by extending parsing and bulk loading functionality across fixed width files and xml documents. For fixed width data, you define columns and the corresponding widths, and optionally the padding character used that should be trimmed, then just loop easily through the data. For xml documents, you define columns by specifying one xpath to loop over the data with, ie /users/user, then specify one xpath per column to obtain that column’s value, ie firstName, then just loop over the data, with full streaming and bulk loading capabilities that will handle any size xml file, even 10 gb.
Version 2.0:

One of the most common tasks involving CSV data in a Microsoft environment is to bulk insert data originating from a CSV file into SQL Server. In the .Net Framework 2.0, MS added a new rarely talked about class called SqlBulkCopy that allows for bulk inserting data from another datasource directly into SQL Server at almost DTS speeds. This new method is much faster even than the new batch insert ability of the SqlDataAdapter that everyone keeps talking about so much. This is the focus of the 2.0 version of the CsvReader framework and the basis for the new class CsvDataReader. Unfortunately, you won’t be able to take advantage of this if you’re still using .Net 1.0 or 1.1, but it might give you a reason to upgrade. Now, even tasks like validating data or manipulating data before insert even becomes a breeze using the ReadRecord event that allows you to add data, modify data, even skip whole rows on the fly while your data is being inserted. It does not require SQL Server 2005 to use it.
                              This post is a paid post

Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.

Copyright Tech Mantra | Theme by DailyBlogTips