public static SpreadsheetGearSeries ReadFromWorkbook(IWorkbook workbook, string sheetName, string dateColumn,
string valueColumn, string siteColumn, string siteFilter, string units)
{
SpreadsheetGearSeries s = new SpreadsheetGearSeries(workbook, sheetName, dateColumn, valueColumn, siteColumn, siteFilter, units);
s.Read();
return(s);
}
public static SpreadsheetGearSeries ReadFromWorkbook(IWorkbook workbook, string sheetName, string dateColumn,
string valueColumn, bool isWaterYearformat, string units)
{
SpreadsheetGearSeries s = new SpreadsheetGearSeries(workbook, sheetName, dateColumn, valueColumn, isWaterYearformat, units);
s.Read();
return(s);
}
public static SpreadsheetGearSeries ReadFromFile(string fileName, string sheetName, string dateColumn,
string valueColumn)
{
SpreadsheetGearSeries s = new SpreadsheetGearSeries(fileName, sheetName, dateColumn, valueColumn);
s.Read();
return(s);
}
/// <summary>
/// Updates database if the original source file still exists and has
/// been modified.
/// </summary>
protected override void UpdateCore(DateTime t1, DateTime t2, bool minimal)
{
Logger.WriteLine("Checking Excel series " + Name + " (" + ID + ") for updates");
string dir = Path.GetDirectoryName(m_db.DataSource);
if (TextSeries.CanUpdateFromFile(ConnectionString, dir))
{
Logger.WriteLine("Update: File has changed");
SpreadsheetGearSeries g = SpreadsheetGearSeries.CreateFromConnectionString(ConnectionString, dir);
g.Read();
//m_db.Truncate(ID);
ConnectionString = g.ConnectionString;
ConnectionString = ConnectionStringUtility.MakeFileNameRelative(ConnectionString, m_db.DataSource);
m_db.SaveProperties(this);// LastWriteTime proabably changed
m_db.SaveTimeSeriesTable(ID, g, DatabaseSaveOptions.DeleteAllExisting);
}
}
public static SpreadsheetGearSeries ReadFromWorkbook(IWorkbook workbook, string sheetName, string dateColumn,
string valueColumn, string siteColumn, string siteFilter, string units)
{
SpreadsheetGearSeries s = new SpreadsheetGearSeries(workbook, sheetName, dateColumn, valueColumn,siteColumn, siteFilter,units);
s.Read();
return s;
}
public static SpreadsheetGearSeries ReadFromWorkbook(IWorkbook workbook, string sheetName, string dateColumn,
string valueColumn, bool isWaterYearformat, string units)
{
SpreadsheetGearSeries s = new SpreadsheetGearSeries(workbook, sheetName, dateColumn, valueColumn,isWaterYearformat,units);
s.Read();
return s;
}
public static SpreadsheetGearSeries ReadFromFile(string fileName, string sheetName, string dateColumn,
string valueColumn)
{
SpreadsheetGearSeries s = new SpreadsheetGearSeries(fileName, sheetName, dateColumn, valueColumn);
s.Read();
return s;
}
