public static void ExportData(out MemoryStream stream)
{
var res = new ResponseContext { Status = 1 };
stream = new MemoryStream();
IWorkbook wb = null;
ISheet sheet = null;
stream.Seek(0, SeekOrigin.Begin);
wb = new XSSFWorkbook();
if (wb != null)
{
sheet = wb.GetSheet("Sheet1");
if (sheet == null)
sheet = wb.CreateSheet("Sheet1");
if (sheet != null)
{
List<string> vs = new List<string> { "aaa", "bbb" };
var rowHeader = sheet.CreateRow(0); //创建第一行,列名
for (int i = 0; i < vs.Count; i++)
{
var cellHeader = rowHeader.CreateCell(i);
cellHeader.SetCellValue(vs[i]);
}
Dictionary<int, string> keyValuePairs = new Dictionary<int, string>();
keyValuePairs.Add(11, Guid.NewGuid().ToString());
keyValuePairs.Add(21, Guid.NewGuid().ToString());
keyValuePairs.Add(31, Guid.NewGuid().ToString());
keyValuePairs.Add(41, Guid.NewGuid().ToString());
keyValuePairs.Add(51, Guid.NewGuid().ToString());
keyValuePairs.Add(61, Guid.NewGuid().ToString());
keyValuePairs.Add(71, Guid.NewGuid().ToString());
keyValuePairs.Add(81, Guid.NewGuid().ToString());
keyValuePairs.Add(91, Guid.NewGuid().ToString());
int j = 0;
foreach (var item in keyValuePairs)
{
j = j + 1;
IRow row = sheet.CreateRow(j);
row.CreateCell(0).SetCellValue(item.Key);
row.CreateCell(1).SetCellValue(item.Value);
}
}
wb.Write(stream);
}
}
/// <summary>
/// 导出Export
/// </summary>
/// <returns></returns>
[HttpGet("GetExport")]
public ActionResult GetExport()
{
daochu.ExportData(out MemoryStream stream);
return File(stream.GetBuffer(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "shi");
}