comment on

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.

In reply to Re: Writing a .txt file for import in Excel with UTF-8 BOM by perldigious
in thread Writing a .txt file for import in Excel with UTF-8 BOM by bradcathey

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


There's more than one way to do things
	PerlMonks