private static List <SpreadSheetExample> ReadFromFile()
{
var largeExamples = new List <SpreadSheetExample>();
var spreadsheet = new ExcelSpreadSheet();
var outPutDirectory = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
var iconPath = Path.Combine(outPutDirectory, @"QuadraticProgramming2.xlsx");
var book = spreadsheet.GetExcelWorkBook(iconPath);
{
var vectors = spreadsheet.ReadRange(book, "QP_Raw50", "BasisVectors");
var target2d = spreadsheet.ReadRange(book, "QP_Raw50", "TargetProfile");
var target = FlattenArray(target2d);
largeExamples.Add(new SpreadSheetExample()
{
Name = "QP_Soln50: 50 Vector problem",
BasisVectors = vectors,
TargetVector = target,
LowerConstraint = 0,
UpperConstraint = 2,
});
}
{
var vectors = spreadsheet.ReadRange(book, "QP_Raw300", "BasisVectors");
var target2d = spreadsheet.ReadRange(book, "QP_Raw300", "TargetProfile");
var target = FlattenArray(target2d);
largeExamples.Add(new SpreadSheetExample()
{
Name = "QP_Soln300: 300 Vector problem",
BasisVectors = vectors,
TargetVector = target,
LowerConstraint = 0,
UpperConstraint = 20,
});
}
GC.Collect();
GC.WaitForPendingFinalizers();
return(largeExamples);
}
private static List<SpreadSheetExample> ReadFromFile()
{
var largeExamples = new List<SpreadSheetExample>();
var spreadsheet = new ExcelSpreadSheet();
var outPutDirectory = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
var iconPath = Path.Combine(outPutDirectory, @"QuadraticProgramming2.xlsx");
var book = spreadsheet.GetExcelWorkBook(iconPath);
{
var vectors = spreadsheet.ReadRange(book, "QP_Raw50", "BasisVectors");
var target2d = spreadsheet.ReadRange(book, "QP_Raw50", "TargetProfile");
var target = FlattenArray(target2d);
largeExamples.Add(new SpreadSheetExample()
{
Name = "QP_Soln50: 50 Vector problem",
BasisVectors = vectors,
TargetVector = target,
LowerConstraint = 0,
UpperConstraint = 2,
});
}
{
var vectors = spreadsheet.ReadRange(book, "QP_Raw300", "BasisVectors");
var target2d = spreadsheet.ReadRange(book, "QP_Raw300", "TargetProfile");
var target = FlattenArray(target2d);
largeExamples.Add(new SpreadSheetExample()
{
Name = "QP_Soln300: 300 Vector problem",
BasisVectors = vectors,
TargetVector = target,
LowerConstraint = 0,
UpperConstraint = 20,
});
}
GC.Collect();
GC.WaitForPendingFinalizers();
return largeExamples;
}
