private void export_2_excel() { CExcelReport v_obj_excel_rpt = new CExcelReport("f404_qua_trinh_cong_tac.xlsx", 3, 1); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); }
private void export_2_excel() { CExcelReport v_obj_excel_rpt = new CExcelReport("f403_bao_cao_nhan_su_cap_bac.xlsx", 3, 1); v_obj_excel_rpt.AddFindAndReplaceItem("<thoi_diem>", m_dtp_thoidiem.Value.Date); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); }
private void export_2_excel() { CExcelReport v_obj_excel_rpt = new CExcelReport("f407_bao_cao_danh_sach_bo_nhiem.xlsx", 3, 2); v_obj_excel_rpt.AddFindAndReplaceItem("<thoi_diem>", m_dtp_thoidiem.Value.Month); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); }
private void export_2_excel() { CExcelReport v_obj_excel_rpt = new CExcelReport("f405_bien_dong_nhan_su_chuc_vu_trang_thai.xlsx", 3, 1); v_obj_excel_rpt.AddFindAndReplaceItem("<thoi_diem>", m_dat_thoidiem.Value.Date); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); }
private void export_2_excel() { CExcelReport v_obj_excel_rpt = new CExcelReport("f408_bao_cao_don_vi_trang_thai.xlsx", 3, 2); v_obj_excel_rpt.AddFindAndReplaceItem("<thoi_diem>", m_dat_thoidiem.Value.Date); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg_donvi, 1, m_fg_donvi.Cols.Count - 1, true); }
private void export_2_excel() { CExcelReport v_obj_excel_rpt = new CExcelReport("f501_bao_cao_nhan_su_du_an_tu_ngay_den_ngay.xlsx", 6, 1); v_obj_excel_rpt.AddFindAndReplaceItem("<tu_ngay>", m_dat_tu_ngay.Value.Date); v_obj_excel_rpt.AddFindAndReplaceItem("<den_ngay>", m_dat_den_ngay.Value.Date); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); }
private void export_2_excel() { CExcelReport v_obj_excel_rpt = new CExcelReport("f409_bao_cao_nghi_viec.xlsx", 3, 2); v_obj_excel_rpt.AddFindAndReplaceItem("<tu_ngay>", m_dtp_tu_ngay.Value); v_obj_excel_rpt.AddFindAndReplaceItem("<den_ngay>", m_dtp_den_ngay.Value); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); }
/*private void set_search_format_before() { * if (m_txt_search.Text == "") { * m_txt_search.Text = m_str_goi_y_tim_kiem; * m_txt_search.ForeColor = Color.Gray; * } * }*/ /*private void set_search_format_after() { * if (m_txt_search.Text == m_str_goi_y_tim_kiem) { * m_txt_search.Text = ""; * } * m_txt_search.ForeColor = Color.Black; * }*/ private void xuat_excel() { var v_start_row = 8; var v_start_col = 1; var v_obj_excel_rpt = new CExcelReport("f104_bao_cao_nhan_su_theo_phong_ban.xlsx", v_start_row, v_start_col); v_obj_excel_rpt.AddFindAndReplaceItem("<ngay_thang>", string.Format("{0}/{1}/{2}", DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year)); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); }
private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e) { if (!backgroundWorker1.CancellationPending) { alert.Message = "In progress, please wait... " + e.ProgressPercentage.ToString() + "%"; alert.ProgressValue = e.ProgressPercentage; } var v_start_row = 2; var v_start_col = 1; var v_obj_excel_rpt = new CExcelReport("Employee.xls", v_start_row, v_start_col); //v_obj_excel_rpt.AddFindAndReplaceItem("<ngay_thang>", string.Format("{0}/{1}/{2}", DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year)); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); }