I am trying to read an excel file (.xlsx) using Apache POI. One of the column of the file has non-english characters in it e.g. บริษัท พัฒนา จำกัด (มหาชน)
If the cell is having any value, then POI reads the cell properly with correct non-english characters. But, if the cell is empty in that particular column, it reads the next cell for the current column name. e.g. if the column4 is having special character type and IS NOT empty, then, POI maps column4 with value in that column properly. But, if the column4 is having special character type and IS empty, then, POI maps column4 with value in column5. This corrupts the complete structure and cellIterator. Please let me know what is the problem and how to solve it? Help will be appreciated. Thanks! -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-Column-having-non-english-characters-e-g-Thai-and-cell-empty-then-skips-the-cell-tp5718229.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]
