public void ResultsBuilder(double Enclosing, int sortBy, bool isRange)
{
ExcelBuilder excelBuilder = new ExcelBuilder(this);
var excel = excelBuilder.Build(Enclosing, sortBy, isRange);
string[][][] excelStringTemplate = excel.Item1;
System.Drawing.Color[][][] excelColorTemplate = excel.Item2;
OutPutSpread.Create(excelStringTemplate.Length);
OutPutSpread.Workbook.Worksheets[0].Name = "Начальные данные";
OutPutSpread.Workbook.Worksheets[1].Name = "Группы";
OutPutSpread.Workbook.Worksheets[2].Name = "Ранжированные данные";
OutPutSpread.Workbook.Worksheets[3].Name = "Корреляция Спирмена";
for (int sheet = 0; sheet < excelStringTemplate.Length; sheet++)
{
if (excelStringTemplate[sheet] != null)
{
for (int column = 0; column < excelStringTemplate[sheet].Length; column++)
{
for (int row = 0; row < excelStringTemplate[sheet][column].Length; row++)
{
OutPutSpread.Workbook.Worksheets[sheet].Range[row + 1, column + 1].Value = excelStringTemplate[sheet][column][row];
}
}
}
if (excelColorTemplate[sheet] != null)
{
for (int column = 0; column < excelColorTemplate[sheet].Length; column++)
{
for (int row = 0; row < excelColorTemplate[sheet][column].Length; row++)
{
if (excelColorTemplate[sheet][column][row].Name != "0")
{
OutPutSpread.Workbook.Worksheets[sheet].Range[row + 1, column + 1].CellStyle.Color = excelColorTemplate[sheet][column][row];
}
}
}
}
}
}
private void SaveExcelResult_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog
{
FileName = InputSpread.FileName + " " + MethodName,
DefaultExt = ".xlsx",
Filter = "Excel (.xlsx)|*.xlsx"
};
Nullable <bool> result = saveFileDialog.ShowDialog();
if (result == true)
{
string FileNameBase = saveFileDialog.FileName;
try
{
OutPutSpread.SaveAs(FileNameBase);
}
catch (IOException e2)
{
e2.StackTrace.ToString();
}
}
}
