private static void CreateDataWorksheet(Excel.Worksheet sheet, LsData lsData, string sheetName)
{
sheet.Name = sheetName;
sheet.Columns[(new XlPosition()).Column].ColumnWidth = 2.5;
SetValue(sheet, LsParameters.BetaName, dataBHeadSp);
SetRowValues(sheet, lsData.Parameters.XValsNames, dataXHeadsSp);
SetValue(
sheet,
lsData.Parameters.YValName,
new XlPosition(
dataXHeadsSp.Row,
dataXHeadsSp.Column + lsData.Parameters.XMtx.ColumnCount));
SetRowValues(sheet, lsData.Parameters.Beta, dataBValsSp);
SetTableValues(sheet, lsData.Parameters.XMtx, dataXValsSp);
SetColumnValues(
sheet,
lsData.Parameters.YVtr,
new XlPosition(
dataXValsSp.Row,
dataXValsSp.Column + lsData.Parameters.XMtx.ColumnCount));
ReleaseMemory(sheet);
}
private static void CreaeteWorksheet(string fileName, LsData lsData, WriteData writeData, bool visible = true)
{
Excel.Application xlApp = new Excel.Application();
if (xlApp == null)
{
return;
}
if (lsData == null)
{
lsData = ExcelWorker.lsData;
}
object misValue = System.Reflection.Missing.Value;
var xlWorkbook = (File.Exists(fileName))
? xlApp.Workbooks.Open(fileName)
: xlApp.Workbooks.Add(misValue);
xlApp.Visible = visible;
Task.Factory.StartNew(() =>
{
writeData(xlWorkbook, lsData);
Save(xlWorkbook, fileName);
ReleaseMemory(xlApp, xlWorkbook);
});
}
private static void CreateParametersWorksheet(Excel.Worksheet sheet, LsData lsData, string sheetName)
{
sheet.Name = sheetName;
sheet.Columns[(new XlPosition()).Column].ColumnWidth = 2.5;
sheet.Columns[paramDHeadsSp.Column].ColumnWidth = 30;
SetColumnValues(sheet, paramDHeads, paramDHeadsSp);
string[] paramsDVals =
{
lsData.Parameters.NumbOfTests.ToString(),
lsData.Parameters.NumbOfXVal.ToString(),
((int)lsData.Parameters.NoiseX).ToString(),
((int)lsData.Parameters.NoiseY).ToString(),
lsData.Parameters.Gamma.ToString(),
lsData.Parameters.Theta.ToString()
};
SetColumnValues(sheet, paramsDVals, paramDValsSp);
SetColumnValues(sheet, paramNsHeads, paramNsHeadSp);
SetColumnValues(sheet, paramNsTys, paramNsTySp);
ReleaseMemory(sheet);
}
/*
* Pre-condition:
* Gets workbook
*
* Post-condition:
* Read Parameters and Data from excel file
* and returns then as LsData
*/
private static LsData GetData(Excel.Workbook workbook)
{
LsData lsData = new LsData();
GetParameters(lsData, workbook.Sheets["Parameters"]);
GetData(lsData, workbook.Sheets["Data"]);
return(lsData);
}
private static void GetParameters(LsData lsData, Excel.Worksheet sheet)
{
lsData.Parameters.NumbOfTests = GetInt(sheet, new XlPosition(paramDValsSp.Row, paramDValsSp.Column));
lsData.Parameters.NumbOfXVal = GetInt(sheet, new XlPosition(paramDValsSp.Row + 1, paramDValsSp.Column));
lsData.Parameters.NoiseX = (NoiseTypes)GetInt(sheet, new XlPosition(paramDValsSp.Row + 2, paramDValsSp.Column));
lsData.Parameters.NoiseY = (NoiseTypes)GetInt(sheet, new XlPosition(paramDValsSp.Row + 3, paramDValsSp.Column));
lsData.Parameters.Gamma = GetDouble(sheet, new XlPosition(paramDValsSp.Row + 4, paramDValsSp.Column));
lsData.Parameters.Theta = GetDouble(sheet, new XlPosition(paramDValsSp.Row + 5, paramDValsSp.Column));
}
private void BtnLoadData_Click(object sender, RoutedEventArgs e)
{
WinForms.OpenFileDialog ofd = new WinForms.OpenFileDialog();
ofd.Filter = "Excel File|*.xls";
lsData =
(ofd.ShowDialog() == WinForms.DialogResult.OK)
? ExcelWorker.GetData(fileName = ofd.FileName)
: null;
}
public DataTableWindow(LsData lsData, LsResult lsResult, string filePath)
{
InitializeComponent();
this.lsData = lsData;
this.lsResult = lsResult;
this.filePath = filePath;
InitializeComponents();
}
private static void GetData(LsData lsData, Excel.Worksheet sheet)
{
lsData.Parameters.InitializeMatrices();
// Read names of X and Y values
ReadRow(sheet, lsData.Parameters.XValsNames, dataXHeadsSp);
lsData.Parameters.YValName = sheet.Cells[dataXHeadsSp.Row, dataXHeadsSp.Column + lsData.Parameters.XMtx.ColumnCount].Value2.ToString();
ReadRow(sheet, lsData.Parameters.Beta, dataBValsSp);
ReadTable(sheet, lsData.Parameters.XMtx, dataXValsSp);
ReadColumn(sheet, lsData.Parameters.YVtr, new XlPosition(dataXValsSp.Row, dataXValsSp.Column + lsData.Parameters.XMtx.ColumnCount));
}
public ChartWindow(LsData lsData)
{
InitializeComponent();
this.lsData = lsData;
ClearChart();
DrawX();
DrawY();
DrawYResults();
}
public static void Save(LsData lsData, SaveType saveType)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel File|*.xls";
if (sfd.ShowDialog() != DialogResult.OK)
{
return;
}
Save(lsData, sfd.FileName, saveType);
}
public static void Save(LsData lsData, string fileName, SaveType saveType)
{
switch (saveType)
{
case SaveType.All:
CreaeteWorksheet(fileName, lsData, WriteAllLsData);
return;
case SaveType.Result:
CreaeteWorksheet(fileName, lsData, WriteResults);
return;
case SaveType.Data:
CreaeteWorksheet(fileName, lsData, WriteParametersAndData);
return;
default:
return;
}
}
/*
* Pre-condition:
* numberOfXValues, numberOfExperiments,
* beta and noise are set
* Post-condition:
* Create lsData which can be used in further calculations
*/
private void BtnGenerateData_Click(object sender, RoutedEventArgs e)
{
if (SldNumberOfXValues.Value < 2)
{
return;
}
int numberOfXValues = (int)SldNumberOfXValues.Value;
int numberOfExperiments = Convert.ToInt32(TbxNumberOfExperiments.Text);
double[] beta = scrollViewerTbx.GetBeta();
DetermineNoiseType();
lsData =
LsDataBuilder.Build(
numberOfXValues,
numberOfExperiments,
beta,
noiseX,
noiseY,
Convert.ToDouble(TbxGamma.Text),
Convert.ToDouble(TbxTheta.Text));
}
private static void WriteResults(Excel.Workbook xlWorkbook, LsData lsData)
{
WriteResults(xlWorkbook, lsData.ResultLs, "Result LS");
WriteResults(xlWorkbook, lsData.ResultIls, "Result ILS");
}
private static void WriteParametersAndData(Excel.Workbook xlWorkbook, LsData lsData)
{
CreateParametersWorksheet(xlWorkbook.Worksheets.Item[1], lsData, "Parameters");
CreateDataWorksheet(xlWorkbook.Worksheets.Add(), lsData, "Data");
}
private static void WriteAllLsData(Excel.Workbook xlWorkbook, LsData lsData)
{
WriteParametersAndData(xlWorkbook, lsData);
WriteResults(xlWorkbook, lsData);
}
