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"; }