Question 252240 in ASP.NET Question posted in
The official documentation can be found here.

ASP.net csv download removes newlines

I need to provide a csv file generated by the server for download by url. The problem is the resulting csv file loses newline symbols. All the data appears on one row (single line), and that is not what I need. Original file is fine, has all lines correctly. a I’m on .Net Framework 4.7.1.

Here’s example code:

public async Task<FileResult> Download()
        {
            string filepath = AppDomain.CurrentDomain.BaseDirectory + $"filename.csv";
            if (!System.IO.File.Exists(filepath))
                System.IO.File.WriteAllText(filepath, "");


            return File(filepath, "text/csv", $"filename.csv");
        }

I have tried multiple things, providing filestream, byte array, but all of that results in the same thing. How can I fix that?

Tags:

2

Answers


  1. 0

    This is how I create my CSV content:

    StringBuilder stringBuilder = new StringBuilder();
var dataSeparator = ";";
var lineTemplate = $"{satirbasligi}{satirverisi}{scrapAddition}";
stringBuilder.Append(lineTemplate.TrimEnd(dataSeparator.ToCharArray()));
stringBuilder.AppendLine();
var csvString = stringBuilder.ToString();

    P.S.: Please note that this not the whole code but just part of it. It needs some collection or some array to iterate on it to create lines.

    You need to use AppendLine at the end of each row when creating the CSV content.

    Edit to original answer:

    This is how i return my file. Maybe this helps

    this.Response.ContentType = "text/csv";
this.Response.Headers.Add("Content-Disposition", $"attachment; filename={reportFileName}");
return File(new System.Text.UTF8Encoding().GetBytes(csvString), "text/csv", reportFileName);

    By the way, I am not creating file in the file system just returning it as a file response to the user.

    Login or Signup to reply.
  2. 0

    The issue you’re experiencing with newline symbols in your CSV file might be related to how line endings are handled in different environments (e.g., Windows, Unix). To ensure that the downloaded CSV file retains proper line endings, you can specify the encoding when writing the file. You should use the StreamWriter class and specify the encoding as follows:

    public async Task<FileResult> Download()
{
    string filepath = AppDomain.CurrentDomain.BaseDirectory + $"filename.csv";

    if (!System.IO.File.Exists(filepath))
    {
        using (StreamWriter writer = new StreamWriter(filepath, false, Encoding.UTF8)) // Specify the desired encoding (UTF-8)
        {
            // Write your CSV data to the file using StreamWriter
            // Example: writer.WriteLine("Column1,Column2,Column3");
        }
    }

    return File(filepath, "text/csv", $"filename.csv");
}

    By using StreamWriter with the UTF-8 encoding (or the encoding that matches your requirements), you should ensure that the line endings are correctly handled, and your downloaded CSV file will have the expected line breaks.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search