I need a code which should get Date from Excel as YYYY-MM-DD format using java

Question

I need a code which should get Date from Excel as YYYY-MM-DD.

It is displaying the date as 31-Dec-2050 which was originally saved in a sheet as 2050-12-31 Format.

System.out.println("<" + sheet.getRow(i).getCell(24) + ">");

should get Date from Excel as YYYY-MM-DD.

Answer 1

Import the following libraries:

import java.time.LocalDate;

import java.time.format.DateTimeFormatter;

Then in your class, execute the following functions:

String cv = sheet.getRow(i).getCell(24).getStringCellValue();

DateTimeFormatter dt = DateTimeFormatter.ofPattern( "uuuu-MM-dd");

System.out.println("<" + LocalDate.parse(cv).format(dt) + ">");