How can I set date to existing excel date cell using java | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

How can I set date to existing excel date cell using java

Use Apache poi api

13th Sep 2019, 4:36 PM
Sixth Sense
Sixth Sense - avatar
1 Answer
+ 2
I'm not sure if I understand what you're trying to do. To parse a date you get the CellValue. The CellValue class provides the getDateCellValue method. The next step is to evaluate the date. You could use a SimpleDateFormat or DateTimeFormatter that matches the CellValue formatting and then create a Date: Date date = dateFormat.parse(myCellValue);
1st Feb 2020, 8:39 PM
Tashi N
Tashi N - avatar