static void Main(string[] args)
{
ExcelDocument document = new ExcelDocument();
document.UserName = "******";
document.CodePage = CultureInfo.CurrentCulture.TextInfo.ANSICodePage;
document.ColumnWidth(0, 120);
document.ColumnWidth(1, 80);
document[0, 0].Value = "ExcelWriter Demo";
document[0, 0].Font = new Font("Tahoma", 10, FontStyle.Bold);
document[0, 0].ForeColor = ExcelColor.DarkRed;
document[0, 0].Alignment = Alignment.Centered;
document[0, 0].BackColor = ExcelColor.Silver;
document.WriteCell(1, 0, "int");
document.WriteCell(1, 1, 10);
document.Cell(2, 0).Value = "double";
document.Cell(2, 1).Value = 1.5;
document.Cell(3, 0).Value = "date";
document.Cell(3, 1).Value = DateTime.Now;
document.Cell(3, 1).Format = @"dd/mm/yyyy";
FileStream stream = new FileStream("demo.xls", FileMode.Create);
document.Save(stream);
stream.Close();
}
// STATUS: this works
/// <summary> Format a date cell </summary>
/// <param name="document">todo: describe document parameter on FormatDate</param>
/// <param name="rowNumber">todo: describe rowNumber parameter on FormatDate</param>
/// <param name="columnNumber">todo: describe columnNumber parameter on FormatDate</param>
public void FormatDate(ExcelDocument document, int rowNumber, int columnNumber)
{
document.Cell(rowNumber, columnNumber).Format = @"dd/mm/yyyy";
}
