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; }