public void DefaultFormat()
{
var dt = new DateTime(2018, 03, 23, 17, 50, 35);
var actual = Converter.Convert(dt, typeof(string), null);
var expected = dt.ToString();
Assert.AreEqual(expected, actual);
}
private void OutputLocaleDataFormats(DateTime date, bool dates, bool times, int style, String styleName)
{
IWorkbook workbook = new HSSFWorkbook();
String sheetName;
if (dates)
{
if (times)
{
sheetName = "DateTimes";
}
else
{
sheetName = "Dates";
}
}
else
{
sheetName = "Times";
}
ISheet sheet = workbook.CreateSheet(sheetName);
IRow header = sheet.CreateRow(0);
header.CreateCell(0).SetCellValue("locale");
header.CreateCell(1).SetCellValue("DisplayName");
header.CreateCell(2).SetCellValue("Excel " + styleName);
header.CreateCell(3).SetCellValue("java.text.DateFormat");
header.CreateCell(4).SetCellValue("Equals");
header.CreateCell(5).SetCellValue("Java pattern");
header.CreateCell(6).SetCellValue("Excel pattern");
int rowNum = 1;
foreach (CultureInfo locale in CultureInfo.GetCultures(CultureTypes.AllCultures))
{
IRow row = sheet.CreateRow(rowNum++);
row.CreateCell(0).SetCellValue(locale.ToString());
row.CreateCell(1).SetCellValue(locale.DisplayName);
string csharpDateFormatPattern;
if (dates)
{
if (times)
{
csharpDateFormatPattern = DateFormat.GetDateTimeInstance(style, style, locale);
}
else
{
csharpDateFormatPattern = DateFormat.GetDateInstance(style, locale);
}
}
else
{
csharpDateFormatPattern = DateFormat.GetTimeInstance(style, locale);
}
//Excel Date Value
ICell cell = row.CreateCell(2);
cell.SetCellValue(date);
ICellStyle cellStyle = row.Sheet.Workbook.CreateCellStyle();
//String csharpDateFormatPattern = locale.DateTimeFormat.LongDatePattern;
String excelFormatPattern = DateFormatConverter.Convert(locale, csharpDateFormatPattern);
IDataFormat poiFormat = row.Sheet.Workbook.CreateDataFormat();
cellStyle.DataFormat = (poiFormat.GetFormat(excelFormatPattern));
cell.CellStyle = (cellStyle);
//C# Date value
row.CreateCell(3).SetCellValue(date.ToString(csharpDateFormatPattern, locale.DateTimeFormat));
// the formula returns TRUE is the formatted date in column C equals to the string in column D
row.CreateCell(4).SetCellFormula("TEXT(C" + rowNum + ",G" + rowNum + ")=D" + rowNum);
//C# pattern
row.CreateCell(5).SetCellValue(csharpDateFormatPattern);
//excel pattern
row.CreateCell(6).SetCellValue(excelFormatPattern);
}
//FileInfo outputFile = TempFile.CreateTempFile("Locale" + sheetName + styleName, ".xlsx");
string filename = "Locale" + sheetName + styleName + ".xls";
FileStream outputStream = new FileStream(filename, FileMode.CreateNew);
try
{
workbook.Write(outputStream);
}
finally
{
outputStream.Close();
}
System.Console.WriteLine("Open " + filename + " in Excel");
}
