在mvc中保存本地机器的文件对话框

Question

想知道是否有人能帮忙。我编写了这段代码，它将生成CSV文件电子表格并将其保存到指定的位置。我想显示一个“另存为”对话框，从存储的位置读取文件，然后询问用户，他们想要存储它的地方。未生成excel文件，在下一个窗口单击"Export“后，它将显示未定义为按摩师！然而，我的问题是，我编写的代码似乎是将文件直接输出到浏览器，因此我在浏览器屏幕上获取CSV文件的所有内容，而不是像预期的那样显示“另存为对话”框！

这是我的密码

  public ActionResult ExportToCSSReport(List<CEPMobility.CEPServiceProxy.CSSReport>  Report) 
        {
            MemoryStream output = new MemoryStream(); 
            StreamWriter writer = new StreamWriter(output, System.Text.Encoding.UTF8);
            writer.WriteLine("PROJECT NAME,CSS ID,CSS Name,Customer Reprentative Name,CSS Recived Date,CSI,TOP 3 STRENGTH,TOP 3 OFI,Any Other COMMENT");
            foreach (CEPMobility.CEPServiceProxy.CSSReport objreport in Report)
            {
                writer.WriteLine("\"" + objreport.PROJECT_NAME + "\",\"" + objreport.CSS_ID + "\",\"" + objreport.CSS_NAME + "\",\"" + objreport.CUST_REP_NAME + "\",\"" + objreport.CSS_RECIEVED_DT + "\",\"" + objreport.CSI + "\",\"" + objreport.TOP_3_STRENGTH + "\",\"" + objreport.TOP_3_OFI + "\",\"" + objreport.COMMENT + "\""); 
            } 
            writer.Flush(); 
            output.Seek(0, SeekOrigin.Begin);
            return File(output, "text/csv", "CSSReport.csv"); 
        }  

作为对gor的回应，它将在顶部显示相同的未定义信息：

public ActionResult ExportToCSSReport(List<CEPMobility.CEPServiceProxy.CSSReport>  Report) 
{
    CEPServiceProxy.CEPDataServiceClient client = null;
    client = new CEPServiceProxy.CEPDataServiceClient();
    lstCSSReport = client.GetCSSReport(cSS_NAME, in_Cust_ID).ToList();
    MemoryStream output = new MemoryStream(); 
    StreamWriter writer = new StreamWriter(output, System.Text.Encoding.UTF8);
    writer.WriteLine("PROJECT NAME,CSS ID,CSS Name,Customer Reprentative Name,CSS Recived Date,CSI,TOP 3 STRENGTH,TOP 3 OFI,Any Other COMMENT");
    foreach (CEPMobility.CEPServiceProxy.CSSReport objreport in Report)
    {
        writer.WriteLine("\"" + objreport.PROJECT_NAME + "\",\"" + objreport.CSS_ID + "\",\"" + objreport.CSS_NAME + "\",\"" + objreport.CUST_REP_NAME + "\",\"" + objreport.CSS_RECIEVED_DT + "\",\"" + objreport.CSI + "\",\"" + objreport.TOP_3_STRENGTH + "\",\"" + objreport.TOP_3_OFI + "\",\"" + objreport.COMMENT + "\""); 
    } 
    writer.Flush(); 
    output.Seek(0, SeekOrigin.Begin);
    Response.AddHeader("Content-Disposition", "attachment;filename=CSSReport.csv");
    return File(output, "text/csv", "CSSReport.csv"); 
}

Answer 1

您应该将Content-Disposition头添加到响应中。如下所示：

Response.AddHeader("Content-Disposition", "attachment;filename=CSSReport.csv");