Export C# List to Csv file

Question

I was trying to export my C# list to Csv file. All is set well. But the thing is field seperator is not working properly. its showing like, my string with " at the end (eg: 0000324df"). Here is my Controller code.

IEnumerable stockexpo = stockexp; // Assign value
        MemoryStream output = new MemoryStream();
        StreamWriter writer = new StreamWriter(output, Encoding.UTF8);
        writer.Write("ItemNo,");
        writer.Write("Repeat Count");
        writer.WriteLine();
        foreach (StockResult order in stockexpo)
        {
            writer.Write(String.Format("{0:d}", order.ItemNumber));
            writer.Write("\"");
            writer.Write(",");
            writer.Write("\"");
            writer.Write(order.Count);
            writer.Write("\"");
            writer.Write(",");
            writer.WriteLine();
        }
        writer.Flush();
        output.Position = 0;

        return File(output, "text/comma-separated-values", "stockexp.csv");

I need to know how i can seperate the field values appropriately. Anyone can help me for this.

Does some of your data contain speachmarks? Looking at your code it is doing exactly what you have asked it to do... — KingCronus
– KingCronus, Commented Aug 16, 2012 at 8:54
No speachmarks in my data. but its (") showing with every value. — Deva
– Deva, Commented Aug 16, 2012 at 9:00
Its like this:0000000027" 0000000028" 0000000029" 0000000030" 0000000031" 0000000032" 0000000033" 0000000034" 0000000035" 0000000036" — Deva
– Deva, Commented Aug 16, 2012 at 9:01

KingCronus · Accepted Answer · 2012-08-16 09:13:31Z

3

  writer.Write("\"");

This line of code will be outputting a " every time. Why have it at all?

Also, I wouldn't have a comma before the WriteLine, since there is no need to delimit the end of the file.

IEnumerable stockexpo = stockexp; // Assign value
    MemoryStream output = new MemoryStream();
    StreamWriter writer = new StreamWriter(output, Encoding.UTF8);
    writer.Write("ItemNo,");
    writer.Write("Repeat Count");
    writer.WriteLine();
    foreach (StockResult order in stockexpo)
    {
        writer.Write(order.ItemNumber);
        writer.Write(",");
        writer.Write(order.Count);
        writer.WriteLine();
    }
    writer.Flush();
    output.Position = 0;

    return File(output, "text/comma-separated-values", "stockexp.csv");

edited Aug 16, 2012 at 9:13

answered Aug 16, 2012 at 9:02

KingCronus

4,5302 gold badges26 silver badges52 bronze badges

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

9 Comments

Deva Over a year ago

This time i am getting the last two chars in the string. like, the actual value => 0000000043. But i am getting only 43.

KingCronus Over a year ago

What is the type of order.ItemNumber?

KingCronus Over a year ago

Then why use String format like you were. See my edited answer.

KingCronus Over a year ago

In that case, your order.ItemNumber is not a string type.

Deva Over a year ago

Its a String and Unique Type.

|

Collectives™ on Stack Overflow

Export C# List to Csv file

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related