コード例 #1
0
        private void load_excel_2_grid(C1.Win.C1FlexGrid.C1FlexGrid m_fg)
        {
            var m_obj_dialog = new System.Windows.Forms.OpenFileDialog();
            DialogResult v_result = new DialogResult();
            v_result = m_obj_dialog.ShowDialog();

            if(v_result == DialogResult.Cancel) {
                BaseMessages.MsgBox_Infor("Bạn chưa chọn file Excel!");
                m_obj_dialog.Dispose();
                return;
            }
            Workbook wb = null;
            wb = Workbook.getWorkbook(m_obj_dialog.FileName);
            Sheet sheet = wb.getSheet(0);
            //Cái này để thêm hàng vào grid
            int v_count_row = 7;
            while(sheet.getCell(2, v_count_row).Contents != "") {
                v_count_row = v_count_row + 1;
                m_fg.Rows.Add();
            }
            wb.close();

            Hashtable v_hst_excel_col = get_mapping_col_excel_grid();
            CExcelReport v_obj_excel_rpt = new CExcelReport(m_obj_dialog.FileName);
            int v_i_start_excel_row = 7;

            for(int v_i_cur_col = m_fg.Cols.Fixed; v_i_cur_col < m_fg.Cols.Count; v_i_cur_col++) {
                m_lbl_loading.Visible = true;
                progressBar1.Visible = true;
                progressBar1.Minimum = m_fg.Cols.Fixed;
                progressBar1.Maximum = m_fg.Cols.Count;
                progressBar1.Value = v_i_cur_col;
                v_obj_excel_rpt.Export2Grid(m_fg,
                    v_i_start_excel_row
                    , (int)v_hst_excel_col[v_i_cur_col]
                    , v_i_cur_col);
            }
            m_lbl_tong_so_bill.Text = CIPConvert.ToStr(count_record_in_grid(m_fg));
            make_stt(m_fg);
            m_lbl_loading.Visible = false;
            progressBar1.Visible = false;
            m_fg.Select(0, 0);
        }