//public static SpreadsheetGearSeries ReadFromConnectionString(string connectionString, // string dataPath) //{ // SpreadsheetGearSeries rval = CreateFromConnectionString(connectionString, dataPath); // rval.Read(); // return rval; //} public static SpreadsheetGearSeries CreateFromConnectionString(string connectionString, string dataPath) { string fileName = ConnectionStringUtility.GetToken(connectionString, "FileName", ""); if (!Path.IsPathRooted(fileName)) { fileName = Path.Combine(dataPath, fileName); } SpreadsheetGearSeries rval = new SpreadsheetGearSeries( fileName, ConnectionStringUtility.GetToken(connectionString, "SheetName", ""), ConnectionStringUtility.GetToken(connectionString, "DateColumn", ""), ConnectionStringUtility.GetToken(connectionString, "ValueColumn", ""), ConnectionStringUtility.GetBoolean(connectionString, "IsWaterYearFormat", false), ConnectionStringUtility.GetToken(connectionString, "SiteColumn", ""), ConnectionStringUtility.GetToken(connectionString, "SiteFilter", "") ); return(rval); }
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 ReadFromFile(string fileName, string sheetName, string dateColumn, string valueColumn) { SpreadsheetGearSeries s = new SpreadsheetGearSeries(fileName, sheetName, dateColumn, valueColumn); 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 ReadFromConnectionString(string connectionString, // string dataPath) //{ // SpreadsheetGearSeries rval = CreateFromConnectionString(connectionString, dataPath); // rval.Read(); // return rval; //} public static SpreadsheetGearSeries CreateFromConnectionString(string connectionString, string dataPath) { string fileName = ConnectionStringUtility.GetToken(connectionString, "FileName", ""); if (!Path.IsPathRooted(fileName)) { fileName = Path.Combine(dataPath, fileName); } SpreadsheetGearSeries rval = new SpreadsheetGearSeries( fileName, ConnectionStringUtility.GetToken(connectionString, "SheetName", ""), ConnectionStringUtility.GetToken(connectionString, "DateColumn", ""), ConnectionStringUtility.GetToken(connectionString, "ValueColumn", ""), ConnectionStringUtility.GetBoolean(connectionString, "IsWaterYearFormat", false), ConnectionStringUtility.GetToken(connectionString,"SiteColumn",""), ConnectionStringUtility.GetToken(connectionString,"SiteFilter","") ); return rval; }