Oh boy, this is gonna be fun.
I need to parse #CSV in #Java. Parsing it into String[][] is easy enough, but here's the hard part: I also need to parse the numbers in the CSV file (into a double, BigDecimal, or the like), and those numbers could be formatted in any of the myriad number/currency formats that Excel might produce.
Web searching isn't getting me very far, and Excel itself is of course closed source so I can't look there.
Any advice would be much appreciated!