YD
Hello Community,
I am now working on a report to write excel tabel, I am using the createExcelWorkbook function.
I have to write a date into the cell and the content of the cell should also be in date format in the excel table. So that when I use a filter to the whole column, I can have a good sorted view of all the dates. (as the example 2020,2019,2018,2017, I change their format manually in the excel). At the moment, all the dates are considered as string and when I use the filter, the dates are not sorted and each date is an independent entry in the filter, instead of being sorted into one year.(as shown in the image the last two enties in the filter).
Thanks in advance!
.png)
Hallo Nikita Martyanov,
thank you very much for your answer.
I have tried this method but however I get the following error when I used it.
.png)
I guess the problem is that the constant is not the suitable value.
I tried other constants which indeed work for this function however I can't get a date format for the cells.
XL_CELL_TYPE_BLANK,
XL_CELL_TYPE_BOOLEAN,
XL_CELL_TYPE_ERROR,
XL_CELL_TYPE_FORMULA
XL_CELL_TYPE_NUMERIC
XL_CELL_TYPE_STRING
Do you have any experience with it? It would be very helpful if you have a small example to show how to convert the cell format to date.
Thanks in advance!
Hi,
if you set the date value using "XlsCell.setCellValue(object)" with a parameter of type java.util.Date, the cell will have the correct data type. The displayed data format for this style can be set by calling for example CellStyle.setDataFormat(Constants.XL_CELL_DATAFORMAT_M_D_YY)
