private void load_excel_2_grid_excel()
{
IP.Core.IPExcelReport.CExcelReport v_obj_excel_report
= new IP.Core.IPExcelReport.CExcelReport(m_txt_file_path.Text);
int v_int_excel_row_cout = v_obj_excel_report.GetCountRow();
m_fg_nha.Rows.Count = v_int_excel_row_cout;
m_fg_excel_nha.Rows.Count = v_int_excel_row_cout;
for (int v_i_grid_col = 1; v_i_grid_col < m_fg_excel_nha.Cols.Count; v_i_grid_col++)
{
v_obj_excel_report.Export2Grid(
m_fg_excel_nha
, 5
, v_i_grid_col
, v_i_grid_col);
}
for (int v_i_cur_row = m_fg_excel_nha.Rows.Count - 1; v_i_cur_row > m_fg_excel_nha.Rows.Fixed; v_i_cur_row--)
{
if (m_fg_excel_nha[v_i_cur_row, 1] == null)
{
m_fg_excel_nha.Rows.Remove(v_i_cur_row);
}
else
if (m_fg_excel_nha[v_i_cur_row, 1].ToString().Trim().Length == 0)
{
m_fg_excel_nha.Rows.Remove(v_i_cur_row);
}
}
}
private void load_excel_2_grid_excel(string ip_str_file_name)
{
IP.Core.IPExcelReport.CExcelReport v_obj_excel_report
= new IP.Core.IPExcelReport.CExcelReport(ip_str_file_name);
int v_int_row_count = v_obj_excel_report.GetCountRow();
m_fg_oto.Rows.Count = v_int_row_count;
m_fg_oto_excel.Rows.Count = v_int_row_count;
for (int v_i_grid_col = 1; v_i_grid_col < m_fg_oto_excel.Cols.Count; v_i_grid_col++)
{
v_obj_excel_report.Export2Grid(
m_fg_oto_excel
, 5
, v_i_grid_col
, v_i_grid_col);
}
for (int v_i_cur_row = m_fg_oto_excel.Rows.Count - 1; v_i_cur_row > m_fg_oto_excel.Rows.Fixed; v_i_cur_row--)
{
if (m_fg_oto_excel[v_i_cur_row, 1] == null)
{
m_fg_oto_excel.Rows.Remove(v_i_cur_row);
}
else
if (m_fg_oto_excel[v_i_cur_row, 1].ToString().Trim().Length == 0)
{
m_fg_oto_excel.Rows.Remove(v_i_cur_row);
}
}
}
