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); }