static void Main(string[] args)
{
var underTest = new Workbook();
var sheet = new Worksheet("Sheet 1");
var styleA = new CellFormat();
styleA.SetBackgroundColor(ExcelColor.Red);
styleA.Border.DiagonalUp = true;
styleA.Border.DiagonalDown = true;
styleA.Border.DiagonalStyle = CellBorderStyle.Thin;
var styleB = new CellFormat
{
Pattern =
{
Style = PatternStyle.LightDown,
ForegroundColor = ExcelColor.Blue
}
};
var styleC = new CellFormat();
styleC.SetBackgroundColor(ExcelColor.Silver);
styleC.Border = CellBorder.MediumBox;
styleC.Font.Bold = true;
for (var i = 0; i < 100; i++)
{
var cellA = new Cell("Abcde");
var cellB = new Cell(1234);
var cellC = new Cell(string.Format("This is row {0:000}", i));
if (i % 2 == 0)
{
cellA.CellFormat = styleA;
cellB.CellFormat = styleB;
cellC.CellFormat = styleC;
}
else
{
cellB.CellFormat.TextControl.RotationStyle = RotationStyle.CounterClockwise;
cellB.CellFormat.TextControl.TextRotation = 45;
cellC.VerticalAlignment = VerticalAlignStyle.Centered;
cellC.CellFormat.Font.Name = "Times New Roman";
cellC.CellFormat.Font.Family = FontFamilyType.Roman;
cellC.CellFormat.Font.Height = 240;
}
sheet.Cells[i, 0] = cellA;
sheet.Cells[i, 1] = cellB;
sheet.Cells[i, 2] = cellC;
sheet.Cells.ColumnWidth[2] = 256 * 15;
}
underTest.Worksheets.Add(sheet);
var filename = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory), "test.xls");
if (File.Exists(filename))
{
File.Delete(filename);
}
underTest.Save(filename);
}
