public static MemoryStream ToCsvMemoryStream(this DataTable dt, string currentUserName) { var temproaryFolder = CommUtils.CreateTemporaryFolder(currentUserName); var filePath = Path.Combine(temproaryFolder, "Temporary.csv"); ExcelUtils.WriteCsv(dt, filePath); var buffer = System.IO.File.ReadAllBytes(filePath); CommUtils.DeleteFolderAync(temproaryFolder); return(new MemoryStream(buffer)); }
public static MemoryStream ToExcelMemoryStream(DataTable table, string fileName, string userName) { var tempFolder = CommUtils.CreateTemporaryFolder(userName); var tempFilePath = Path.Combine(tempFolder, fileName); ExcelUtils.TableToExcel(table, tempFilePath); var buffer = System.IO.File.ReadAllBytes(tempFilePath); CommUtils.DeleteFolderAync(tempFolder); return(new MemoryStream(buffer)); }