public ActionResult OutItemTemplate()
{
var resultMsg = "";
try
{
DataTable dtData = new DataTable("table");
dtData.Columns.Add("列名", Type.GetType("System.String"));
dtData.Columns.Add("列名", Type.GetType("System.String"));
dtData.Columns.Add("列名", Type.GetType("System.String"));
dtData.Columns.Add("列名", Type.GetType("System.String"));
dtData.Columns.Add("列名", Type.GetType("System.String"));
dtData.Columns.Add("列名", Type.GetType("System.String"));
dtData.Columns.Add("列名", Type.GetType("System.Decimal"));
dtData.Columns.Add("列名", Type.GetType("System.Decimal"));
DataRow dr = dtData.NewRow();
dtData.Rows.Add(dr);
//创建Excel文件的对象
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
//添加一个sheet
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
//给sheet1添加第一行的头部标题
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
//row1.RowStyle.FillBackgroundColor = "";
for (int i = 0; i < dtData.Columns.Count; i++)
{
row1.CreateCell(i).SetCellValue(dtData.Columns[i].ColumnName);
}
//将数据逐步写入sheet1各个行
for (int i = 0; i < dtData.Rows.Count; i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
for (int j = 0; j < dtData.Columns.Count; j++)
{
rowtemp.CreateCell(j).SetCellValue(dtData.Rows[i][j].ToString().Trim());
}
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
return File(ms, "application/vnd.ms-excel", "询价物料导入模板.xls");
}
catch (Exception ex)
{
resultMsg = ex.Message;
}
finally
{
ViewBag.ResultMsg = resultMsg;
}
return View();
}
模板下载的实现
最新推荐文章于 2023-04-24 10:36:29 发布