Hello Developers,
I am using Jdeveloper 12.2.1. My requirement is to export data into excel that is working perfectly. but when I open excel so all the data comes into General(String) format and I want
Number into Number format and Date into Date format.
I used below code to change format for Date but its still coming in general(String) Format.
(("Birthdate".equalsIgnoreCase(colName))) {
CellStyle cellStyle = workbook.createCellStyle();
CreationHelper createHelper = workbook.getCreationHelper();
cellStyle.setDataFormat(
createHelper.createDataFormat().getFormat("dd-MMM-yy"));
cell.setCellValue(CellValue);
cell.setCellStyle(cellStyle);
Please help.