ozlerhakan / poiji

:candy: A library converting XLS and XLSX files to a list of Java objects based on Apache POI
MIT License
466 stars 134 forks source link

Reading Excel With japanese character, that include phonetic text #290

Closed huatam391 closed 1 year ago

huatam391 commented 1 year ago

Currenly i'm using v4.1.1 When parse value from excel .xlsx format to java class, i got problem if cell value is japanese character, it will read cell value include phonetic text at end of string image Expect: companyNm: 株式会社日工 branchNm: 大阪名古屋工場 But actual: company: 株式会社日工 branchNm: 大阪名古屋工場 オオサカ ナゴヤ コウジョウ Result of branchNm include furigana at the end of string

github-actions[bot] commented 1 year ago

Thank you for contributing to Poiji! Feel free to create a PR If you want to contribute directly :)

ozlerhakan commented 1 year ago

Hi @huatam391 ,

Thanks for sharing this situation with us! It's very strange behavior I see here, perhaps there is something hidden in the file you use or this intentionally behaves differently. Could you share your file, so I can investigate the issue?

huatam391 commented 1 year ago

フォーマット_インポート:宿泊施設 (1).xlsx @ozlerhakan this file is here, i think this issue happen cause new feature phonetic of excel (support furigana for Japanese character). Thank you very much for reply me.

stale[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

ozlerhakan commented 1 year ago

Sadly, I'm not able to open your excel properly using the numbers app on my mac. Feel free to create a PR with the fix for your case!