private void btnImportExcel_Click(object sender, EventArgs e)
{
//ClearTables();
//m_admin.ImpRDGExcelValues(m_listTECComponentIndex[comboBoxTecComponent.SelectedIndex], mcldrDate.SelectionStart);
DataTable import_csv = new DataTable();
OpenFileDialog files = new OpenFileDialog();
files.Multiselect = false;
files.InitialDirectory = FormMain.formParameters.m_arParametrSetup[(int)FormParameters.PARAMETR_SETUP.KOMDISP_FOLDER_CSV]; //@"\\ne2844\2.X.X\ПБР-csv"; //@"E:\Temp\ПБР-csv";
files.DefaultExt = @"xls";
files.Filter = @"xls файлы (*.xls)|*.xls|xlsx файлы(*.xlsx)|*.xlsx";
files.Title = "Выберите файл с ПБР...";
if (files.ShowDialog(FormMain.formParameters) == DialogResult.OK)
{
import_csv = Get_DataTable_From_Excel.getDT(files.FileName, m_admin.m_curDate.Date);
}
//dgwAdminTable.Rows.Clear();
for (int i = 0; i < import_csv.Rows.Count; i++)
{
for (int b = 0; b < import_csv.Columns.Count; b++)
{
if (b != (int)Get_DataTable_From_Excel.INDEX_COLUMN.Time)
{
dgwAdminTable.Rows[i].Cells[b].Value = (Convert.ToDouble(import_csv.Rows[i][b].ToString().Trim())).ToString("F2");
}
}
}
}
public DataTable ImportExcel(string path, out int err)
{
err = -1;
DataTable table_res = new DataTable();
table_res = Get_DataTable_From_Excel.getDT(path, m_curDate.Date, out err);
if (err > (int)Get_DataTable_From_Excel.INDEX_ERR.NOT_ERR)
{
warningReport(Get_DataTable_From_Excel.str_err[err]);
}
return(table_res);
}
