I am not sure I understand your use of the word format here. In Excel's terminology, format actually relates to the physical appearance of a value in the cell; think of a monetary amount, it could appear in the cell as £12,456.00 and the format of this would relate to the currency symbol, the thousand and decimal separators, the number of digits after the decimal point and so on. If this is what you have to check then all you need to do is obtain the cells contents as a formatted string and use regular expressions to cehck that the string conforms to your specification. From the example, you cite however, it would seem that you have to test the type of value the cell contains and determine whether you have encountered a string, a number, a date, etc.
Before I can answer your question with any confidence, I need to know what exactly you are after, format or type, and ask that you tell me which please. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-check-if-Excel-values-are-matching-with-my-format-tp3379567p3379698.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
