Remove header row from CSV and write list of string to stream

Question

var reader = new StreamReader(File.OpenRead(@"C:\sample.csv"));
List<string> listA = new List<string>();
string line1;
Stream originalStream = null;
while (!reader.EndOfStream)
{                
    line1 = reader.ReadLine();
    listA.Add(line1);                
}
listA.RemoveAt(0);
originalStream = listA;

Here I am trying to remove first row and thats ok but after removing it I have other records in list of string which I want to write in a Stream variable. can anybody tell me how can i achieve that.

Thanks

That looks incredibly inefficient, RemoveAt is O(n) operation. Instead of removing the header, just skip from adding it to the list in the first place. And why would you want a list of string as stream? What are you actually trying to do here? — Martheen
– Martheen, Commented Nov 24, 2016 at 5:02
Do you want to write this list to a memory stream or to another file? — Seminda
– Seminda, Commented Nov 24, 2016 at 5:19

sujith karivelil · Accepted Answer · 2016-11-24 05:17:33Z

3

Reading all lines from file to a list and then removing one will not be fair, instead for whole those process i would like to suggest you a one liner like the following:

List<string> listA = System.IO.File.ReadAllLines(@"C:\sample.csv").Skip(1).ToList();

Use this lines to make Stream from List:

 var binFormatter = new BinaryFormatter();
 Stream streamList = null;
 binFormatter.Serialize(streamList, listA);

edited Nov 24, 2016 at 5:17

answered Nov 24, 2016 at 5:04

sujith karivelil

29.1k7 gold badges60 silver badges90 bronze badges

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

5 Comments

Biztalker Over a year ago

Thanks, actually I am trying to build Biztalk pipeline component for that the output can only be in stream or streamreader as per my knowledge

Biztalker Over a year ago

is there a way to read the file in stream or streamreader and skip the first row(without list)

sujith karivelil Over a year ago

I had few updates to the answer, you can take a look

Biztalker Over a year ago

Hi I am getting below error "The type or namespace name 'var' could not be found (are you missing a using directive or an assembly reference?)"

sujith karivelil Over a year ago

use using System.Runtime.Serialization.Formatters.Binary; to solve that error

Collectives™ on Stack Overflow

Remove header row from CSV and write list of string to stream

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related