I finally found an excuse to use POI / HSSF to read Excel. One goal is to read Excel and display the data with the similar formatting - text format only, don't care about colors, fonts, borders, etc. I'm good so far with strings and numbers but I'm having a time with date. For the predefined "m/d/yy" format in Excel ...
cell.getCellStyle().getDataFormat()
gives me decimal 166, 167 etc which are not in the documented list of formats. The format
string is
[$-409]m/d/yy\ h:mm\ AM/PM;@
I played around with sanitizing this into something SimpleDateFormat could consume, but came here when I realized Excel put lower case "m" in both date and time.
Has anybody here already solved this problem?