How to determine if a cell with a sheet extension contains a date or a real number?

When a cell in a spreadsheet contains a simple date (mm / dd / yyyy), the poi API places the cell type as "numeric". This is probably because tables (IMO) historically recognize only strings and real numbers.

You can hard-code the cell index and use it conditionally to call 'getDateCellValue'. But that sounds like a hack.

What other ways are there in the poi API to determine if the content in a cell is a date, not a real number?

+3
source share
1 answer
+5

Source: https://habr.com/ru/post/1741508/


All Articles