/** * Set a date value for the cell. Excel treats dates as numeric so you will need to format the * cell as a date. * * <p>This will set the cell value based on the Calendar's timezone. As Excel does not support * timezones this means that both 20:00+03:00 and 20:00-03:00 will be reported as the same value * (20:00) even that there are 6 hours difference between the two times. This difference can be * preserved by using <code>setCellValue(value.getTime())</code> which will automatically shift * the times to the default timezone. * * @param value the date value to set this cell to. For formulas we'll set the precalculated * value, for numerics we'll set its value. For othertypes we will change the cell to a * numeric cell and set its value. */ public void setCellValue(Calendar value) { boolean date1904 = getSheet().getWorkbook().isDate1904(); setCellValue(DateUtil.getExcelDate(value, date1904)); }
/** * Set a string value for the cell. * * @param str value to set the cell to. For formulas we'll set the formula cached string result, * for String cells we'll set its value. For other types we will change the cell to a string * cell and set its value. If value is null then we will change the cell to a Blank cell. */ public void setCellValue(String str) { setCellValue(str == null ? null : new XSSFRichTextString(str)); }