private static void AddChart(ExcelRange rng,string name, string prefix)
{
var chrt = (ExcelPieChart)rng.Worksheet.Drawings.AddChart(name, eChartType.Pie);
chrt.SetPosition(rng.Start.Row-1, 0, rng.Start.Column-1, 0);
chrt.To.Row = rng.Start.Row+9;
chrt.To.Column = rng.Start.Column + 9;
chrt.Style = eChartStyle.Style18;
chrt.DataLabel.ShowPercent = true;
var serie = chrt.Series.Add(rng.Offset(2, 2, 1, 2), rng.Offset(1, 2, 1, 2));
serie.Header = "Hits";
chrt.Title.Text = "Hit ratio";
var n1 = rng.Worksheet.Names.Add(prefix + "Misses", rng.Offset(2, 2));
n1.Value = 0;
var n2 = rng.Worksheet.Names.Add(prefix + "Hits", rng.Offset(2, 3));
n2.Value = 0;
rng.Offset(1, 2).Value = "Misses";
rng.Offset(1, 3).Value = "Hits";
}
private static void CreateBoard(ExcelRange rng)
{
rng.Style.Fill.Gradient.Color1.SetColor(Color.FromArgb(0x80, 0x80, 0XFF));
rng.Style.Fill.Gradient.Color2.SetColor(Color.FromArgb(0x20, 0x20, 0XFF));
rng.Style.Fill.Gradient.Type = ExcelFillGradientType.None;
for (int col = 0; col <= rng.End.Column - rng.Start.Column; col++)
{
for (int row = 0; row <= rng.End.Row - rng.Start.Row; row++)
{
if (col % 4 == 0)
{
rng.Offset(row, col, 1, 1).Style.Fill.Gradient.Degree = 45;
}
if (col % 4 == 1)
{
rng.Offset(row, col, 1, 1).Style.Fill.Gradient.Degree = 70;
}
if (col % 4 == 2)
{
rng.Offset(row, col, 1, 1).Style.Fill.Gradient.Degree = 110;
}
else
{
rng.Offset(row, col, 1, 1).Style.Fill.Gradient.Degree = 135;
}
}
}
rng.Style.Border.Top.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin;
rng.Style.Border.Top.Color.SetColor(Color.Gray);
rng.Style.Border.Right.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin;
rng.Style.Border.Right.Color.SetColor(Color.Gray);
rng.Style.Border.Left.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin;
rng.Style.Border.Left.Color.SetColor(Color.Gray);
rng.Style.Border.Bottom.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin;
rng.Style.Border.Bottom.Color.SetColor(Color.Gray);
rng.Offset(0, 0, 1, rng.End.Column - rng.Start.Column+1).Style.Border.Top.Color.SetColor(Color.Black);
rng.Offset(0, 0, 1, rng.End.Column - rng.Start.Column + 1).Style.Border.Top.Style=ExcelBorderStyle.Medium;
int rows=rng.End.Row - rng.Start.Row;
rng.Style.Border.BorderAround(ExcelBorderStyle.Medium, Color.Black);
}
private static void CreateBoard(ExcelRange rng)
{
//Create a gradiant background with one dark and one light blue color
rng.Style.Fill.Gradient.Color1.SetColor(Color.FromArgb(0x80, 0x80, 0XFF));
rng.Style.Fill.Gradient.Color2.SetColor(Color.FromArgb(0x20, 0x20, 0XFF));
rng.Style.Fill.Gradient.Type = ExcelFillGradientType.None;
for (int col = 0; col <= rng.End.Column - rng.Start.Column; col++)
{
for (int row = 0; row <= rng.End.Row - rng.Start.Row; row++)
{
if (col % 4 == 0)
{
rng.Offset(row, col, 1, 1).Style.Fill.Gradient.Degree = 45;
}
if (col % 4 == 1)
{
rng.Offset(row, col, 1, 1).Style.Fill.Gradient.Degree = 70;
}
if (col % 4 == 2)
{
rng.Offset(row, col, 1, 1).Style.Fill.Gradient.Degree = 110;
}
else
{
rng.Offset(row, col, 1, 1).Style.Fill.Gradient.Degree = 135;
}
}
}
//Set the inner cell border to thin, light gray
rng.Style.Border.Top.Style = ExcelBorderStyle.Thin;
rng.Style.Border.Top.Color.SetColor(Color.Gray);
rng.Style.Border.Right.Style = ExcelBorderStyle.Thin;
rng.Style.Border.Right.Color.SetColor(Color.Gray);
rng.Style.Border.Left.Style = ExcelBorderStyle.Thin;
rng.Style.Border.Left.Color.SetColor(Color.Gray);
rng.Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
rng.Style.Border.Bottom.Color.SetColor(Color.Gray);
//Solid black border around the board.
rng.Style.Border.BorderAround(ExcelBorderStyle.Medium, Color.Black);
}
/// <summary>
/// Sets all borders in a given range (thanks EPPlus and Codeplex)
/// </summary>
/// <param name="this"></param>
/// <param name="borderStyle"></param>
private void SetAllBorders(ExcelRange @this, ExcelBorderStyle borderStyle)
{
var fromRow = @this.Start.Row;
var fromCol = @this.Start.Column;
var toRow = @this.End.Row;
var toCol = @this.End.Column;
var numRows = toRow - fromRow + 1;
var numCols = toCol - fromCol + 1;
@this.Style.Border.BorderAround(borderStyle);
for (var rowOffset = 1; rowOffset < numRows; rowOffset += 2)
{
var row = @this.Offset(rowOffset, 0, 1, numCols);
row.Style.Border.BorderAround(borderStyle);
}
for (var colOffset = 1; colOffset < numCols; colOffset += 2)
{
var col = @this.Offset(0, colOffset, numRows, 1);
col.Style.Border.BorderAround(borderStyle);
}
}