in reply to Writing a .txt file for import in Excel with UTF-8 BOM
Maybe this is too obvious to even suggest, but have you tried messing around with the import options in Excel?
Not sure what version of Excel you have, but something like this?
I only suggest it since it seems like there should be a way to get Excel to recognize a UTF-8 text file, at least I'd hope that's a problem Microsoft has licked at this point. But I'm told I often give Microsoft too much credit. :-)
UPDATE: Or instead of importing the text file you create in to Excel you could try having Perl create the Excel file directly?
Just another Perl hooker - My clients appreciate that I keep my code clean but my comments dirty.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Writing a .txt file for import in Excel with UTF-8 BOM
by bradcathey (Prior) on Aug 25, 2017 at 00:20 UTC | |
by poj (Abbot) on Aug 25, 2017 at 06:09 UTC |
In Section
Seekers of Perl Wisdom