c# - 在 C# 中使用 ExcelLibrary 输出到 Excel

Question

以下代码使用 controller.file 输出到 csv 文件。我想将其更改为输入到 Excel 工作表 (.xls) 而不是 csv 文件。我从这里使用这个库来做这个.. http://code.google.com/p/excellibrary/

根据这篇 stackoverflow 帖子.. Create Excel (.XLS and .XLSX) file from C#

编辑:

foreach (var value in valueDataList)

    {
        var value1 = xxxxxxx    // this value is set here based on a query.. 
        int value2 = xxxxxxxx   // this value is set here based on a query.. 

        byte[] content;

        using (var ms = new MemoryStream())  
           {
              using (var writer = new StreamWriter(ms))
                {
                  writer.WriteLine("ValueHeading1   " + " ValueHeading2");
                  writer.WriteLine(value1 + "              " + value2);                         
                }
                  content = ms.ToArray();
                  return File(content, "text/csv", "demo.csv");
            //ExcelLibrary.DataSetHelper.CreateWorkbook("MyExcelTest.xls", content);

           }
    }   

如何使用此库修改现有代码以将 putput 转换为 excel。代码中最后注释的行不起作用，因为它希望“内容”是数据集而不是字节。感谢您的帮助。

Answer 1

public ActionResult Excel()
{
    DataSet ds = ...
    using (var ms = new MemoryStream())  
    {
        ExcelLibrary.DataSetHelper.CreateWorkbook(ms, ds)
        return File(ms.ToArray(), "application/vnd.ms-excel", "demo.xls");
    }
}