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
}
