private void WriteDataToWorkSheet(IScriptWorker CurrentScriptWorker, Excel.Worksheet xlWorkSheet, out int RowCounter, out int ColumnCounterForNamesOfTests)
{
xlWorkSheet.Cells[1, 1] = "";
dynamic DatesOfTests = CurrentScriptWorker.GetDatesOfTests();
RowCounter = 2;
foreach (dynamic CurrentDate in DatesOfTests)
{
xlWorkSheet.Cells[RowCounter, 1] = CurrentDate;
++RowCounter;
}
dynamic TestsForSave = CurrentScriptWorker.GetListOfTests();
ColumnCounterForNamesOfTests = 2;
foreach (dynamic CurrentTest in TestsForSave)
{
xlWorkSheet.Cells[1, ColumnCounterForNamesOfTests] = (string)CurrentTest.GetTestName();
dynamic CurrentTestResults = CurrentTest.GetValues();
int RowCounterForTestValues = 2;
foreach (dynamic CurrentValue in CurrentTestResults)
{
xlWorkSheet.Cells[RowCounterForTestValues, ColumnCounterForNamesOfTests] = CurrentValue;
++RowCounterForTestValues;
}
++ColumnCounterForNamesOfTests;
}
}
public void SaveDataInExcel(IScriptWorker CurrentScriptWorker, string SavePath)
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlApp.Visible = true;
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
int RowCounter, ColumnCounterForNamesOfTests;
WriteDataToWorkSheet(CurrentScriptWorker, xlWorkSheet, out RowCounter, out ColumnCounterForNamesOfTests);
CreateGraph(CurrentScriptWorker, xlWorkSheet, RowCounter, ColumnCounterForNamesOfTests);
if (SavePath == null || SavePath == string.Empty)
{
SavePath = Directory.GetCurrentDirectory() + MyResources.Texts.DefaultFileName;
}
xlWorkBook.SaveAs(SavePath, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
MessageBox.Show(MyResources.Texts.ExcelFileWasCreatedMessage + SavePath);
}
private void CreateGraph(IScriptWorker CurrentScriptWorker, Excel.Worksheet xlWorkSheet, int RowCounter, int ColumnCounterForNamesOfTests)
{
Excel.Range chartRange;
Excel.ChartObjects xlCharts = (Excel.ChartObjects)xlWorkSheet.ChartObjects(Type.Missing);
Excel.ChartObject myChart = xlCharts.Add(100, 200, 800, 350);
Excel.Chart chartPage = myChart.Chart;
chartRange = xlWorkSheet.get_Range((Excel.Range)xlWorkSheet.Cells[1, 1], (Excel.Range)xlWorkSheet.Cells[RowCounter - 1, ColumnCounterForNamesOfTests - 1]);
chartPage.ChartWizard(Source: chartRange,
Gallery: Excel.XlChartType.xlColumnClustered,
Title: (string)CurrentScriptWorker.GetLabName(),
CategoryTitle: (string)CurrentScriptWorker.GetValueSeparator(),
ValueTitle: (string)CurrentScriptWorker.GetValueType());
}
private void CreateGraph(IScriptWorker CurrentWorker, string ScriptFullName, string CurrentSaveFullName, string PathToLibraries)
{
try
{
CurrentWorker.LoadScript(ScriptFullName, PathToLibraries);
MainGraphCreator.SaveDataInExcel(CurrentWorker, CurrentSaveFullName);
}
catch (Exception CurrentException)
{
MessageBox.Show(CurrentException.Message, MyResources.Texts.Error, MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
ProgramBusy = false;
}
}
