public void SimpleRead()
{
string filename = TestData.DataPath + "\\SpecificationTestData.xls";
Assert.IsTrue(System.IO.File.Exists(filename), "missing file " + filename);
Series s = SpreadsheetGearSeries.ReadFromFile(filename, "Sheet1", "Date", "JulianDay");
for (int i = 0; i < s.Messages.Count; i++)
{
Console.WriteLine(s.Messages[i]);
}
Assert.IsTrue(s.Count > 789, "not enough points" + filename);
}
public void ConnectionString()
{
string filename = TestData.DataPath + "\\SpecificationTestData.xls";
Assert.IsTrue(System.IO.File.Exists(filename), "missing file " + filename);
Series s = SpreadsheetGearSeries.ReadFromFile(filename, "Sheet1", "Date", "JulianDay");
int count = s.Count;
Assert.IsTrue(s.Count > 100);
s.Clear();
Assert.IsTrue(s.Count == 0);
Series s2 = SpreadsheetGearSeries.CreateFromConnectionString(s.ConnectionString, "");
s2.Read();
Assert.AreEqual(count, s2.Count);
}
private void newExcel_Click(object sender, EventArgs e)
{
if (openExcelDialog.ShowDialog() == DialogResult.OK)
{
SelectExcelSeries dlg = new SelectExcelSeries(openExcelDialog.FileName);
if (dlg.ShowDialog() == DialogResult.OK)
{
Series s = SpreadsheetGearSeries.ReadFromFile(dlg.WorkBook, dlg.SheetName, dlg.DateColumn, dlg.ValueColumn);
if (s.Count > 0)
{
DB.AddSeries(s, tree1.SelectedID);
}
else
{
MessageBox.Show("No data in the selection. File " + openExcelDialog.FileName);
}
}
}
}