Over the last few years, most of my development efforts have been focused on financial applications. Often it is my job to make the analysts’ lives easier by providing online tools to help better manage their data. But as many of you know, financial analysts love spreadsheets and the majority of information is stored and shared via CSV files. With this in mind, even the slickest of applications must incorporate the use of spreadsheets or it isn’t going to be quickly or happily adopted.
Recently, I was introduced to CSV Reader. It’s a .NET class which provides a fast and reliable way to handle stream based parsing of virtually any delimited data format.
Parsing is done using de facto standard CSV file specifications which give you the ability to open, edit and save CSV files directly from your code.
Additionally, the latest version of the product introduces the CsvDataReader class which simplifies the common task of bulk inserting CSV data into SQL Server. This class provides on-the-fly data validation and manipulation using the ReadRecord event.
With this said, CSV Reader was designed for speed. The product site touts that data can be parsed in less than half of the time of any other parser it has been benchmarked against.
I downloaded the demo version of the library and I was impressed by its ease of use. The product site provides sufficient examples and the sample project (in C# and VB) provides a glimpse into the CSV Reader’s performance. I didn’t test the edit/save feature, but in conjunction with the snappy file parsing, this product may be a worthwhile investment.
Check out the CSV Reader and decide for yourself.
This was a paid review.
For people on a tight budget and need something cheap (free), check out the FileHelper project. I recently integrated this library into an automated CSV parser. Parses pretty much any delimited format you can throw at it AND its free!. W00t.
http://www.codeproject.com/use.....elpers.asp
Thanks for the suggestion, Alex.
I have fun with, lead to I found just what I used to be looking for. You have ended my four day lengthy hunt! God Bless you man. Have a great day. Bye
Is using a copyright material as a reference to write articles illegal?
Thanks for your useful post. In recent times, I have come to understand that the symptoms of mesothelioma cancer are caused by your build up associated fluid involving the lining on the lung and the torso cavity. The disease may start inside the chest spot and spread to other parts of the body. Other symptoms of pleural mesothelioma include weight reduction, severe breathing in trouble, nausea, difficulty ingesting, and bloating of the neck and face areas. It must be noted that some people living with the disease do not experience any serious indicators at all.
Can I just say what a relief to find someone who truly is aware of what theyre speaking about on the internet. You definitely know easy methods to convey a problem to mild and make it important. More people need to read this and perceive this aspect of the story. I cant consider youre no more widespread because you definitely have the gift.
Learning info displayed here I noticed some useful conclusions. I’d really like to value the effort suffered in publishing.
I’m having a small problem. I cannot subscribe to your rss feed for some reason. I’m using google reader by the way.
Very good information can be found on website .
A Muslim, A non-U.S. Citezen, plus a damaging us president to best it off of.
Bookmarked this post and look forward to coming back again. Great job!
Sarah Palin dosen’t use a snowfall balls probability in hell, Way Too Greatly Loathe From the Pigs To the Lead
Just desire to say your article is as surprising. The clarity in your post is simply nice and i could assume you’re an expert on this subject. Well with your permission let me to grab your feed to keep updated with forthcoming post. Thanks a million and please carry on the enjoyable work.
Obama is nearly almost nothing further as opposed to fluff on best of his supervisor.
We appreciate all of the suggestions as well as data we have obtained from the individuals of this site. We will certainly continue to observe the subject matters right here as well as hope to offer the identical quantity of valued information.
check out this exceptional array of doggy snuggies along with rugs. you get all of the best
Argan oil is on details that many people do not in fact understand a whole lot concerning. Its kind of a puzzle oil that individuals merely invest in. Effectively we have the fact about products that consist of argan oil. So come by our web site.
some truly superb info , Sword lily I noticed this.
I went over this site and I conceive you have a lot of good information, saved to favorites (:.
some truly good info , Gladiola I observed this.
Can I simply say what a relief to search out somebody who truly is aware of what theyre speaking about on the internet. You undoubtedly know tips on how to convey an issue to gentle and make it important. Extra people have to learn this and perceive this facet of the story. I cant imagine youre not more well-liked since you definitely have the gift.
When I originally commented I clicked the -Notify me when new feedback are added- checkbox and now each time a remark is added I get four emails with the same comment. Is there any manner you may take away me from that service? Thanks!