private void ImportFileInExcelFormat() { OpenFileDialog openFileDialog2 = new OpenFileDialog(); openFileDialog2.Multiselect = false; if (openFileDialog2.ShowDialog() == DialogResult.OK) { try { string mapname = string.Empty; string realmapname = string.Empty; int tildeindex = openFileDialog2.FileName.LastIndexOf("~"); bool symbolfound = false; if (tildeindex > 0) { tildeindex++; mapname = openFileDialog2.FileName.Substring(tildeindex, openFileDialog2.FileName.Length - tildeindex); mapname = mapname.Replace(".xls", ""); mapname = mapname.Replace(".XLS", ""); mapname = mapname.Replace(".Xls", ""); // look if it is a valid symbolname foreach (SymbolHelper sh in Tools.Instance.m_symbols) { if (sh.Varname.Replace(",", "").Replace("[","").Replace("]","") == mapname || sh.Userdescription.Replace(",", "") == mapname) { symbolfound = true; realmapname = sh.Varname; if (MessageBox.Show("Found valid symbol for import: " + sh.Varname + ". Are you sure you want to overwrite the map in the binary?", "Confirmation", MessageBoxButtons.YesNo) == DialogResult.Yes) { // ok, overwrite info in binary } else { mapname = string.Empty; // do nothing realmapname = string.Empty; } } } if (!symbolfound) { // ask user for symbol designation frmSymbolSelect frmselect = new frmSymbolSelect(Tools.Instance.m_symbols); if (frmselect.ShowDialog() == DialogResult.OK) { mapname = frmselect.SelectedSymbol; realmapname = frmselect.SelectedSymbol; } } } else { // ask user for symbol designation frmSymbolSelect frmselect = new frmSymbolSelect(Tools.Instance.m_symbols); if (frmselect.ShowDialog() == DialogResult.OK) { mapname = frmselect.SelectedSymbol; realmapname = frmselect.SelectedSymbol; } } if (realmapname != string.Empty) { ImportExcelSymbol(realmapname, openFileDialog2.FileName); } } catch (Exception E) { frmInfoBox info = new frmInfoBox("Failed to import map from excel: " + E.Message); } } }