/// <summary> /// DataTable写入数据流 /// </summary> /// <param name="dt">数据源</param> /// <param name="stream">数据流</param> /// <param name="columns">DataTable 中的列及Excel中的标题组成的键值对</param> /// <param name="sheetName">sheet名称</param> public static void ExportExcel(Stream stream, DataTable dt, Dictionary <string, string> columns, string sheetName = "Sheet") { if (columns == null || columns.Count == 0) { throw (new ArgumentNullException("columns", "请设置要导出的列名")); } if (dt == null || dt.Rows.Count == 0) { throw new ArgumentNullException("dt", "请设置导出的数据"); } HSSFWorkbook workbook = CreateExcelFile(); workbook.CreateRows(dt.Rows, columns); workbook.SaveExcelFile(stream); }