Ok, got a problem that I can't seem to find any useful, relevant information on so I really need some help! I am creating Excel files with Apache POI in my application. Everything is working great except accented characters are showing up wrongly like Guant,namo/Guantn�namo, C,te D'Ivoire/C�te D'Ivoire etc.
Just replacing the accented characters with their closest equivalent like '�' to 'o' is no good, my boss does *not* compromise
I can create a simple CSV easily and it all works fine with that, and it can be loaded into Excel and works there too (but that's not good enough either).
Thanks in advance!