CsvHelperでCSVファイルをダウンロードpublic ActionResult Export() { var records = new List<object>() { new { Id = 123, Name = "abc"}, new { Id = 456, Name = "xyz"}, }; // Output the csv file using (var memStream = new MemoryStream()) using (var streamWriter = new StreamWriter(memStream) { AutoFlush = true }) using (var csvWriter = new CsvWriter(streamWriter)) { csvWriter.WriteRecords((IEnumerable) records); streamWriter.Flush(); memStream.Flush(); memStream.Position = 0; var utf8 = Encoding.UTF8; var sjis = Encoding.GetEncoding("Shift_JIS"); Byte[] bytes = Encoding.Convert(utf8, sjis, memStream.ToArray()); return File(new MemoryStream(bytes, 0, bytes.Length), "text/csv", "test.csv"); } } 参考
http://msdn.microsoft.com/ja-jp/library/system.io.memorystream.getbuffer(v=vs.110).aspx |
|