I have problem while reading date from excel file. I use following:
FileInputStream inputStream = new FileInputStream(excelFilePath);
Workbook workbook = new XSSFWorkbook(inputStream);
Sheet firstSheet = workbook.getSheetAt(0);
Iterator<Row> rowIterator = firstSheet.iterator();
Cell nextCell = cellIterator.next();
Date testTimestamp = nextCell.getDateCellValue();
This lead me to ERROR:
Cannot get a NUMERIC value from a STRING cell
Column in excel is type of General (I tried also Date, Time, Text, Number)
Value in this column is like: 2023-10-11 13:20:43.000
Thank you in advance for help