excel NPOI导出
/// <summary>
/// 导出excel
/// </summary>
/// <param name="dt"></param>
/// <param name="Name">导出的数据名称</param>
/// <param name="IsDown">是否在浏览器下载</param>
public static void ExportExcel(this DataTable dt, string Name = "", bool IsDown = false)
{
try
{
//创建一个工作簿
IWorkbook workbook = new HSSFWorkbook();
if (string.IsNullOrWhiteSpace(Name))
{
Name = "导出的数据";
}
//创建一个 sheet 表
ISheet sheet = workbook.CreateSheet(Name);
//创建一行
IRow rowH = sheet.CreateRow(0);
//创建一个单元格
ICell cell = null;
//创建单元格样式
//ICellStyle cellStyle = workbook.CreateCellStyle();
//创建格式
//IDataFormat dataFormat = workbook.CreateDataFormat();
//设置为文本格式,也可以为 text,即 dataFormat.GetFormat("text");
//cellStyle.DataFormat = dataFormat.GetFormat("@");
//标头格式
var HeadStyle = CreateCellStyle(workbook, true);
var BodyStyle = CreateCellStyle(workbook, false);
//设置列名
foreach (DataColumn col