private void SaveDownload(string fileName, WarrantyList list) { var workbook = new HSSFWorkbook(); var worksheet = workbook.CreateSheet("Report"); ExcelWorker.CellStyles = new List <ICellStyle>(); ExcelWorker.CreateRow(worksheet, 0, new ExcelCell[] { ExcelWorker.CreateCell(workbook, "Kho", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Mã", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Nhân viên", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Mã hóa đơn", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Khách hàng", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Ngày tạo", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Ngày chuyển đi TTBH", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Ngày TTBH nhận", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Ngày chuyển đến CH", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Ngày CH nhận", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Ngày giao hàng", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Phí", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Khuyến mãi", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Ghi chú", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index), ExcelWorker.CreateCell(workbook, "Khác", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index) }); for (var i = 0; i < list.Data.Count; i++) { var record = list.Data[i]; ExcelWorker.CreateRow(worksheet, i + 1, new ExcelCell[] { ExcelWorker.CreateCell(workbook, record.WarehouseName), ExcelWorker.CreateCell(workbook, record.Code), ExcelWorker.CreateCell(workbook, record.EmployeeName), ExcelWorker.CreateCell(workbook, record.OrderCode), ExcelWorker.CreateCell(workbook, record.ClientName), ExcelWorker.CreateCell(workbook, record.SubmitDate.ToString(Constants.DateTimeString)), ExcelWorker.CreateCell(workbook, record.TransferDate.HasValue ? record.TransferDate.Value.ToString(Constants.DateString) : ""), ExcelWorker.CreateCell(workbook, record.ReceivedDate.HasValue ? record.ReceivedDate.Value.ToString(Constants.DateString) : ""), ExcelWorker.CreateCell(workbook, record.ProcessedDate.HasValue ? record.ProcessedDate.Value.ToString(Constants.DateString) : ""), ExcelWorker.CreateCell(workbook, record.ReturnedDate.HasValue ? record.ReturnedDate.Value.ToString(Constants.DateString) : ""), ExcelWorker.CreateCell(workbook, record.FinishDate.ToString(Constants.DateString)), ExcelWorker.CreateCell(workbook, record.FeeString), ExcelWorker.CreateCell(workbook, record.DiscountString), ExcelWorker.CreateCell(workbook, record.Note), ExcelWorker.CreateCell(workbook, record.Other) }); } ExcelWorker.CreateRow(worksheet, list.Data.Count + 1, new ExcelCell[] { ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, "Tổng cộng"), ExcelWorker.CreateCell(workbook, list.Data.Sum(i => i.Fee).GetCurrencyString()), ExcelWorker.CreateCell(workbook, list.Data.Sum(i => i.Discount).GetCurrencyString()), ExcelWorker.CreateCell(workbook, ""), ExcelWorker.CreateCell(workbook, "") }); using (var fs = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write)) { workbook.Write(fs); } }