public void StyleExcel_Sales(IWorkbook workbook, IWorksheet sheet) { IStyle pageHeader = workbook.Styles.Add("PageHeaderStyle"); IStyle tableHeader = workbook.Styles.Add("TableHeaderStyle"); pageHeader.Color = Syncfusion.Drawing.Color.FromArgb(69, 90, 100); pageHeader.Font.RGBColor = Syncfusion.Drawing.Color.White; pageHeader.Font.FontName = "Calibri"; pageHeader.Font.Size = 18; pageHeader.Font.Bold = true; pageHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; pageHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Font.Color = ExcelKnownColors.Black; tableHeader.Font.Bold = true; tableHeader.Font.Size = 12; tableHeader.Font.FontName = "Calibri"; tableHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; tableHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin; sheet["A1"].Text = "Báo cáo Doanh số"; sheet["A1"].CellStyle = pageHeader; sheet["A2"].Text = "Mã báo cáo"; sheet["A2"].CellStyle.Font.Bold = false; sheet["A2"].CellStyle.Font.Size = 12; sheet["A3"].Text = "Tháng"; sheet["A3"].CellStyle.Font.Bold = false; sheet["A3"].CellStyle.Font.Size = 12; sheet["A4"].Text = "Nhân viên"; sheet["A4"].CellStyle.Font.Bold = false; sheet["A4"].CellStyle.Font.Size = 12; sheet["A1:E1"].Merge(); sheet["A5"].Text = "STT"; sheet["B5"].Text = "Hiệu xe"; sheet["C5"].Text = "Số lượt sửa"; sheet["D5"].Text = "Thành tiền"; sheet["E5"].Text = "Tỉ lệ"; sheet["A5:E5"].CellStyle = tableHeader; sheet.AutofitColumn(1); sheet.UsedRange.AutofitColumns(); }
public void StyleExcel_ThongTinHangXe(IWorkbook workbook, IWorksheet sheet) { IStyle pageHeader = workbook.Styles.Add("PageHeaderStyle"); IStyle tableHeader = workbook.Styles.Add("TableHeaderStyle"); pageHeader.Color = Syncfusion.Drawing.Color.FromArgb(69, 90, 100); pageHeader.Font.RGBColor = Syncfusion.Drawing.Color.White; pageHeader.Font.FontName = "Calibri"; pageHeader.Font.Size = 18; pageHeader.Font.Bold = true; pageHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; pageHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Font.Color = ExcelKnownColors.Black; tableHeader.Font.Bold = true; tableHeader.Font.Size = 12; tableHeader.Font.FontName = "Calibri"; tableHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; tableHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin; sheet["A1"].Text = "Thông tin hãng xe"; sheet["A1"].CellStyle = pageHeader; sheet["A1:B1"].Merge(); sheet["A4"].Text = "ID"; sheet["B4"].Text = "Hãng xe"; sheet["A4:B4"].CellStyle = tableHeader; sheet.AutofitColumn(1); sheet.UsedRange.AutofitColumns(); }
public void StyleExcel_LichSuNhapHang(IWorkbook workbook, IWorksheet sheet) { IStyle pageHeader = workbook.Styles.Add("PageHeaderStyle"); IStyle tableHeader = workbook.Styles.Add("TableHeaderStyle"); pageHeader.Color = Syncfusion.Drawing.Color.FromArgb(69, 90, 100); pageHeader.Font.RGBColor = Syncfusion.Drawing.Color.White; pageHeader.Font.FontName = "Calibri"; pageHeader.Font.Size = 18; pageHeader.Font.Bold = true; pageHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; pageHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Font.Color = ExcelKnownColors.Black; tableHeader.Font.Bold = true; tableHeader.Font.Size = 12; tableHeader.Font.FontName = "Calibri"; tableHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; tableHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin; sheet["A1"].Text = "Lịch sử nhập hàng"; sheet["A1"].CellStyle = pageHeader; sheet["A1:E1"].Merge(); sheet["A2"].Text = "Tháng"; sheet["A3"].Text = "Năm"; sheet["A4"].Text = "Tên vật tư"; sheet["B4"].Text = "Số lượng"; sheet["C4"].Text = "Đơn giá"; sheet["D4"].Text = "Ngày nhập"; sheet["E4"].Text = "Tổng chi phí"; sheet["A4:E4"].CellStyle = tableHeader; sheet.AutofitColumn(1); sheet.UsedRange.AutofitColumns(); }
public void StyleExcel_LichSuKinhDoanh(IWorkbook workbook, IWorksheet sheet) { IStyle pageHeader = workbook.Styles.Add("PageHeaderStyle"); IStyle tableHeader = workbook.Styles.Add("TableHeaderStyle"); pageHeader.Color = Syncfusion.Drawing.Color.FromArgb(69, 90, 100); pageHeader.Font.RGBColor = Syncfusion.Drawing.Color.White; pageHeader.Font.FontName = "Calibri"; pageHeader.Font.Size = 18; pageHeader.Font.Bold = true; pageHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; pageHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Font.Color = ExcelKnownColors.Black; tableHeader.Font.Bold = true; tableHeader.Font.Size = 12; tableHeader.Font.FontName = "Calibri"; tableHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; tableHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin; sheet["A1"].Text = "Lịch sử kinh doanh"; sheet["A1"].CellStyle = pageHeader; sheet["A1:E1"].Merge(); sheet["A2"].Text = "Tháng"; sheet["A3"].Text = "Năm"; sheet["A4"].Text = "Mã hóa đơn"; sheet["B4"].Text = "Tên khách hàng"; sheet["C4"].Text = "Biển số xe"; sheet["D4"].Text = "Ngày thanh toán"; sheet["E4"].Text = "Doanh thu"; sheet["A4:E4"].CellStyle = tableHeader; sheet.AutofitColumn(1); sheet.UsedRange.AutofitColumns(); }
protected void gvDepartment_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e) { try { ExcelExport exp = new ExcelExport(); IWorkbook book = exp.Export(gvDepartment.Model, (IEnumerable)gvDepartment.DataSource, ExportFileName + ".xlsx", ExcelVersion.Excel2010, false, false, "flat-lime", true); //Creating a new style with cell back color, fill pattern and font attribute Syncfusion.XlsIO.IStyle headerStyle = book.Styles.Add("NewStyle"); headerStyle.Font.Bold = true; headerStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter;//set text alignment headerStyle.Color = Color.FromArgb(229, 255, 204); headerStyle.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin; headerStyle.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin; headerStyle.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin; headerStyle.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin; // Inserted new row for adding title book.ActiveSheet.InsertRow(1); // Merging the sheet from Range A1 to D1 for adding title space book.ActiveSheet.Range["A1:D1"].Merge(); book.ActiveSheet.Range["E1:H1"].Merge(); //Adding the title using Text property book.ActiveSheet.Range["A1"].Text = ReportTitle; book.ActiveSheet.Range["A1"].CellStyle = headerStyle; book.ActiveSheet.Range["E1"].Value = "Report Generated Date: " + DateTime.Now.ToString("dd-MMM-yyyy hh:mm tt"); book.ActiveSheet.Range["E1"].CellStyle = headerStyle; book.ActiveSheet.Name = "Master Dept"; //Adding footer using SetValue method book.SaveAs(ExportFileName + ".xlsx", ExcelSaveType.SaveAsXLS, System.Web.HttpContext.Current.Response, ExcelDownloadType.Open); } catch (Exception ex) { // CU.LogError(ex); } }
public void StyleExcel_DanhSachXe(IWorkbook workbook, IWorksheet sheet) { IStyle pageHeader = workbook.Styles.Add("PageHeaderStyle"); IStyle tableHeader = workbook.Styles.Add("TableHeaderStyle"); pageHeader.Color = Syncfusion.Drawing.Color.FromArgb(69, 90, 100); pageHeader.Font.RGBColor = Syncfusion.Drawing.Color.White; pageHeader.Font.FontName = "Calibri"; pageHeader.Font.Size = 18; pageHeader.Font.Bold = true; pageHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; pageHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Font.Color = ExcelKnownColors.Black; tableHeader.Font.Bold = true; tableHeader.Font.Size = 12; tableHeader.Font.FontName = "Calibri"; tableHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; tableHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin; sheet["A1"].CellStyle = pageHeader; sheet["A1:F1"].Merge(); sheet["A2"].Text = "ID"; sheet["B2"].Text = "Biển số"; sheet["C2"].Text = "Hiệu xe"; sheet["D2"].Text = "Chủ xe"; sheet["E2"].Text = "Tiền nợ"; sheet["F2"].Text = "Ngày tiếp nhận"; sheet["A2:F2"].CellStyle = tableHeader; sheet.AutofitColumn(1); sheet.UsedRange.AutofitColumns(); }
public void StyleExcel_DanhSachNhaCungCap(IWorkbook workbook, IWorksheet sheet) { IStyle pageHeader = workbook.Styles.Add("PageHeaderStyle"); IStyle tableHeader = workbook.Styles.Add("TableHeaderStyle"); pageHeader.Color = Syncfusion.Drawing.Color.FromArgb(69, 90, 100); pageHeader.Font.RGBColor = Syncfusion.Drawing.Color.White; pageHeader.Font.FontName = "Calibri"; pageHeader.Font.Size = 18; pageHeader.Font.Bold = true; pageHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; pageHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Font.Color = ExcelKnownColors.Black; tableHeader.Font.Bold = true; tableHeader.Font.Size = 12; tableHeader.Font.FontName = "Calibri"; tableHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; tableHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin; sheet["A1"].Text = "Danh sách nhà cung cấp"; sheet["A1"].CellStyle = pageHeader; sheet["A1:D1"].Merge(); sheet["A2"].Text = "ID"; sheet["B2"].Text = "Tên nhà cung cấp"; sheet["C2"].Text = "Số điện thoại"; sheet["D2"].Text = "Email"; sheet["A2:D2"].CellStyle = tableHeader; sheet.AutofitColumn(1); sheet.UsedRange.AutofitColumns(); }
public void StyleExcel_Inventory(IWorkbook workbook, IWorksheet sheet) { // THIẾT LẬP CÁI FILE EXCEL NÓ RA SAO IStyle pageHeader = workbook.Styles.Add("PageHeaderStyle"); IStyle tableHeader = workbook.Styles.Add("TableHeaderStyle"); // này là tạo style 1 cái là header 1 cái là header của cái table pageHeader.Color = Syncfusion.Drawing.Color.FromArgb(69, 90, 100); pageHeader.Font.RGBColor = Syncfusion.Drawing.Color.White; pageHeader.Font.FontName = "Calibri"; pageHeader.Font.Size = 18; pageHeader.Font.Bold = true; pageHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; pageHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; // thiết lập cho header (copy) tableHeader.Font.Color = ExcelKnownColors.Black; tableHeader.Font.Bold = true; tableHeader.Font.Size = 12; tableHeader.Font.FontName = "Calibri"; tableHeader.HorizontalAlignment = ExcelHAlign.HAlignCenter; tableHeader.VerticalAlignment = ExcelVAlign.VAlignCenter; tableHeader.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin; tableHeader.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin; // cho table (copy) //Apply style to the header sheet["A1"].Text = "Báo cáo tồn"; sheet["A1"].CellStyle = pageHeader; sheet["A2"].Text = "Mã báo cáo"; sheet["A2"].CellStyle.Font.Bold = false; sheet["A2"].CellStyle.Font.Size = 12; sheet["A3"].Text = "Tháng"; sheet["A3"].CellStyle.Font.Bold = false; sheet["A3"].CellStyle.Font.Size = 12; sheet["A4"].Text = "Nhân viên"; sheet["A4"].CellStyle.Font.Bold = false; sheet["A4"].CellStyle.Font.Size = 12; // này là gán dữ liệu vào mấy cái ô sheet["A1:E1"].Merge(); // này là hợp nhất mấy cái ô từ đâu đến đâu sheet["A5"].Text = "STT"; sheet["B5"].Text = "Vật tư phụ tùng"; sheet["C5"].Text = "Tồn đầu"; sheet["D5"].Text = "Phát sinh"; sheet["E5"].Text = "Tồn cuối"; sheet["A5:E5"].CellStyle = tableHeader; // này cũng là gán chữ sheet.AutofitColumn(1); sheet.UsedRange.AutofitColumns(); // copy }