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