Creating CSV file

Question

using c#, open or reading a text file (source csv file) and . Finally, I have to create another csv file for these lines. Should I create a data table and insert each line after processing and finally export the data table to a csv file. OR Create a csv file before starting foreach {} and write to this csv file for each line.

How would you do it?

I'm lazy StreamWriter with a formatted WriteLine or if it's complicate LinqToCSV assembly — kenny
– kenny, Commented Dec 8, 2010 at 13:57
I think LinqToCSV requires .net 3.5 or above and I know the machine where they will be running this tool only has .net 2.0 framework. I will look into this. Thanks Kenny — Bob Dinero
– Bob Dinero, Commented Dec 8, 2010 at 14:07

Aim Kai · Accepted Answer · 2010-12-08 14:04:46Z

1

The stream way is definitely the way to go!

Although a few years old now - I've used this csv reader framework LumenWorks.Framework.IO.Csv in a few projects and it has worked fine..

http://www.codeproject.com/KB/database/CsvReader.aspx

answered Dec 8, 2010 at 14:04

Aim Kai

2,9291 gold badge24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Adam Lear Over a year ago

It's not really old. It's been updated last month to version 3.7.1.

Bob Dinero Over a year ago

Our company process to adopt new or open source framework is EXTREMELY discouraging, therefore, I wont be able to use this solution.

Aim Kai Over a year ago

Probably best to go with a stream reader then if you cannot use this component. You can look at the code and take inspiration from what they have done as opposed to adding a reference to the component. The source code is available.

n8wrl · Accepted Answer · 2010-12-08 13:57:26Z

0

Depends on how big the orignal file is. In general, it helps scalability to stream like your 2nd option - to NOT load something completely into memeory if you don't really know how big it could be.

answered Dec 8, 2010 at 13:57

n8wrl

19.8k4 gold badges70 silver badges106 bronze badges

1 Comment

Bob Dinero Over a year ago

It could be 100 lines or 1000 lines.

Collectives™ on Stack Overflow

Creating CSV file

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related