private void ImportExcelDatabaseStyle(string filename)
{
#if !PISCES_OPEN
var dlg = new ImportExcelDatabase(filename, DB.GetUniqueUnits());
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
var messageList = new List <string>();
for (int i = 0; i < dlg.SelectedSites.Length; i++)
{
Series s = SpreadsheetGearSeries.ReadFromWorkbook(dlg.WorkBook,
dlg.SheetName, dlg.DateColumn, dlg.ValueColumn, dlg.SiteColumn, dlg.SelectedSites[i], 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. Site: " + dlg.SelectedSites[i]);
}
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 ImportExcelDatabaseStyle(string filename)
{
#if !PISCES_OPEN
var dlg = new ImportExcelDatabase(filename, DB.GetUniqueUnits());
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
var messageList = new List<string>();
for (int i = 0; i < dlg.SelectedSites.Length; i++)
{
Series s = SpreadsheetGearSeries.ReadFromWorkbook(dlg.WorkBook,
dlg.SheetName, dlg.DateColumn, dlg.ValueColumn, dlg.SiteColumn, dlg.SelectedSites[i],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. Site: " + dlg.SelectedSites[i]);
}
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
}
