CODEWITHSUNDEEP
asp.net-mvc-3export-to-excelfilecontentresult
Jeff Reddy
Jeff Reddy

Reputation: 5670

MVC3 Download Excel Workbook from CSV data

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.

Upvotes: 0

Views: 1066

Answers (1)

Alleo
Alleo

Reputation: 8528

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);

Upvotes: 1

Related Questions