private void ImportExcelStandard(string filename)
{
#if !PISCES_OPEN
ImportExcelStandard dlg = new ImportExcelStandard(filename, DB.GetUniqueUnits());
if (dlg.ShowDialog() == DialogResult.OK)
{
var messageList = new List <string>();
for (int i = 0; i < dlg.ValueColumns.Length; i++)
{
Series s = SpreadsheetGearSeries.ReadFromWorkbook(dlg.WorkBook, dlg.SheetName, dlg.DateColumn, dlg.ValueColumns[i], false, dlg.ComboBoxUnits.Text);
if (s.Count > 0)
{
DB.AddSeries(s, CurrentFolder);
}
else
{
//messageList.Add("No data in the selection. File " + openExcelDialog.FileName);
messageList.Add("No data in the selection. Worksheet: " + dlg.SheetName);
}
if (s.Messages.Count > 0)
{
messageList.Add(s.Messages.ToString());
}
}
if (messageList.Count > 0)
{
MessageBox.Show(String.Join("\n", messageList.ToArray()), "Import Warnings", MessageBoxButtons.OK);
}
}
#endif
}
private void ImportExcelStandard(string filename)
{
#if !PISCES_OPEN
ImportExcelStandard dlg = new ImportExcelStandard(filename, DB.GetUniqueUnits());
if (dlg.ShowDialog() == DialogResult.OK)
{
var messageList = new List<string>();
for (int i = 0; i < dlg.ValueColumns.Length; i++)
{
Series s = SpreadsheetGearSeries.ReadFromWorkbook(dlg.WorkBook, dlg.SheetName, dlg.DateColumn, dlg.ValueColumns[i],false,dlg.ComboBoxUnits.Text);
if (s.Count > 0)
{
DB.AddSeries(s, CurrentFolder);
}
else
{
//messageList.Add("No data in the selection. File " + openExcelDialog.FileName);
messageList.Add("No data in the selection. Worksheet: " + dlg.SheetName);
}
if (s.Messages.Count > 0)
{
messageList.Add(s.Messages.ToString());
}
}
if (messageList.Count > 0)
{
MessageBox.Show(String.Join("\n",messageList.ToArray()),"Import Warnings",MessageBoxButtons.OK);
}
}
#endif
}
