/// <summary> /// 生成Excel文件流 /// </summary> /// <param name="result"></param> /// <param name="type"></param> /// <param name="sheetName"></param> /// <returns></returns> public static byte[] GenerateFileStream(DataTable dtResult, EnumExportFileType type, string sheetName = "Sheet1") { if (dtResult == null || dtResult.Rows.Count == 0 || dtResult.Columns.Count == 0) { return(null); } byte[] result = null; switch (type) { case EnumExportFileType.Xls: result = ExcelUtility.GenerateExcelFileStream(dtResult, true , 0, 0, SaveFormat.Excel97To2003, 1, 1, false, "yyyy-MM-dd", false, sheetName); break; case EnumExportFileType.Xlsx: result = ExcelUtility.GenerateExcelFileStream(dtResult, true , 0, 0, SaveFormat.Xlsx, dtResult.Rows.Count, dtResult.Columns.Count, false, "yyyy-MM-dd", false, sheetName); break; case EnumExportFileType.Txt: result = TxtUtility.GetExportBytes(dtResult); break; case EnumExportFileType.Pdf: break; } return(result); }
/// <summary> /// 生成文件流 /// </summary> /// <param name="titles"></param> /// <param name="fields"></param> /// <param name="list"></param> /// <param name="type"></param> /// <param name="sheetName"></param> /// <returns></returns> public static byte[] GenerateFileStream(string[] titles, string[] fields, ICollection list, EnumExportFileType type, string sheetName = "Sheet1") { byte[] result = null; switch (type) { case EnumExportFileType.Xls: result = ExcelUtility.GenerateExcelFileStream(titles, fields, list, SaveFormat.Excel97To2003, false, 1, 0, true, "yyyy-MM-dd", false, sheetName); break; case EnumExportFileType.Xlsx: result = ExcelUtility.GenerateExcelFileStream(titles, fields, list, SaveFormat.Xlsx, false, 1, 0, true, "yyyy-MM-dd", false, sheetName); break; case EnumExportFileType.Txt: case EnumExportFileType.Pdf: break; } return(result); }