public void LargeImport() { Performance perf = new Performance(); string dataPath = TestData.DataPath; string fn = @"T:\PN6200\Staff\KTarbet\PiscesSampleData\CraigAddley\Testout.txt"; Console.WriteLine(fn); Assert.IsTrue(File.Exists(fn), "Missing file " + fn); SpreadsheetGearExcel xls = new SpreadsheetGearExcel(fn); perf.Report("done reading " + fn); Series s = SpreadsheetGearSeries.ReadFromWorkbook(xls.Workbook, "sheet1", "DateTime", "flow", false, "cfs"); s.Read(); Assert.AreEqual(666282, s.Count); //Series s = new ExcelDataReaderSeries(fn, "sheet1", "DateTime", "flow","cfs"); perf.Report("done importing excel file"); /* * 666282 records * * SaveTable ==> 286 seconds * InsertTable ==> 64 seconds */ // perform exceedance calculation //ExplorerView v = new ExplorerView(); //Explorer explorer = new Explorer(v, db); //explorer.MonthDayRange }
private void ImportExcelWaterYear(string filename) { #if !PISCES_OPEN var dlg = new ImportExcelWaterYear(filename, DB.GetUniqueUnits()); if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { for (int i = 0; i < dlg.SheetNames.Length; i++) { SpreadsheetGearSeries s = SpreadsheetGearSeries.ReadFromWorkbook(dlg.WorkBook, dlg.SheetNames[i], dlg.DateColumn, dlg.ValueColumn, true, dlg.ComboBoxUnits.Text); s.Name = "Monthly" + s.SheetName; if (s.Count > 0) { DB.AddSeries(s, CurrentFolder); } else { //MessageBox.Show("No data in the selection. File " + openExcelDialog.FileName); MessageBox.Show("No data in selection. Worksheet: " + s.SheetName); } if (s.Messages.Count > 0) { MessageBox.Show(s.Messages.ToString(), "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 }
private void ImportExcelDatabaseStyle(string filename) { 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); } } }