MVC3 Download Excel Workbook from CSV data

Question

I've got a set of data that exists in memory in a CSV format. I have this method in my controller:

     public FileContentResult ItemsAsExcelExport(){
         var model = _itemService.GetExcelExportModel();
        return new FileContentResult(model.CSVData, model.MimeType){FileDownloadName = model.FileName};
     }

The problem here is that my model.CSVData property returns a simple comma delimited set of values. I'm not sure how I can satisfy the fileContents argument of the FileContentResult contructor. It's asking for a byte array.

Thanks in advance.

score 1 · Accepted Answer · edited May 23 '17 at 11:55

1

Take a look at this question How do I get a consistent byte representation of strings in C# without manually specifying an encoding?

The solution is

  byte[] b1 = System.Text.Encoding.UTF8.GetBytes (myString);

edited May 23 '17 at 11:55

Community

1
1

answered Aug 30 '11 at 18:50

Alleo

6,116
2
32
29

Will this alter my data at all? – Jeff Reddy Aug 30 '11 at 18:51
No, of course not. It simply converts your string into array of bytes. Nothing more – Alleo Aug 30 '11 at 18:55

MVC3 Download Excel Workbook from CSV data

1 Answers1