我之前问过这个问题,但在启动文件下载方面仍然有困难。
var fileName = "ExcelData.xlsx";
var file = new FileInfo(fileName);
using (var package = new OfficeOpenXml.ExcelPackage(file))
{
var worksheet = package.Workbook.Worksheets.FirstOrDefault(x => x.Name == "Employee Data");
if (package.Workbook.Worksheets.FirstOrDefault(x => x.Name == "Employee Data") == null)
{
worksheet = package.Workbook.Worksheets.Add("Employee Data");
}
else
{
package.Workbook.Worksheets.Delete(1);
worksheet = package.Workbook.Worksheets.Add("Employee Data");
}
worksheet.Cells[1, 1].Value = "Date start";
worksheet.Cells[1, 2].Value = "Name";
var rowCounter = 2;
foreach (var v in users)
{
string dt = v.DateAdded.ToString();
worksheet.Cells[rowCounter, 1].Value = dt;
worksheet.Cells[rowCounter, 2].Value = v.Name;
rowCounter++;
}
package.Workbook.Properties.Title = "Employee Data";
System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
response.Clear();
response.Buffer = true;
response.Charset = "";
response.ContentType = "application/vnd.openxmlformats- officedocument.spreadsheetml.sheet";
response.AddHeader("content-disposition", "attachment;filename=ExcelData.xlsx");
response.BinaryWrite(package.GetAsByteArray());
}
目前代码没有报错,但下载也没有被触发。如何触发下载,使生成的文件被保存到默认下载文件夹中。