Re^2: Writing a .txt file for import in Excel with UTF-8 BOM

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

Yes, I did learn that you can import the file into Excel with UTF-8 as an option and all is fine but trying to make the experience for the client a little smoother. I guess MS doesn't take UTF-8 straight out of the box. Strange.

I have used Excel::Template in the past, but for my purposes it would be complicated to set up and looking for something quick. But nothing is quick when programming, right.

Thanks!

—Brad
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot

Comment on Re^2: Writing a .txt file for import in Excel with UTF-8 BOM

Replies are listed 'Best First'.
Re^3: Writing a .txt file for import in Excel with UTF-8 BOM by poj (Abbot) on Aug 25, 2017 at 06:09 UTC
If you want to open the file in Excel with a double mouse click rather than using the text import wizard, File::BOM will work or just add another print line to your script. `#!perl use strict; use utf8; #use File::BOM(); #open my $fh, '>:utf8 :via(File::BOM)','output_with_bom.csv' # or die "$!"; open my $fh, '>:utf8','output_with_bom.csv' or die "$!"; print $fh chr(0xFEFF); # U+FEFF is EF BB BF as utf-8 print $fh $_ for <DATA>; close $fh; __DATA__ a,1 b,2 Š,3 Ž,4` [download] poj	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: Writing a .txt file for import in Excel with UTF-8 BOM
by poj (Abbot) on Aug 25, 2017 at 06:09 UTC

If you want to open the file in Excel with a double mouse click rather than using the text import wizard, File::BOM will work or just add another print line to your script.

#!perl
use strict;
use utf8;
#use File::BOM(); 
#open my $fh, '>:utf8 :via(File::BOM)','output_with_bom.csv' 
#      or die "$!";

open my $fh, '>:utf8','output_with_bom.csv' or die "$!";
print $fh chr(0xFEFF); # U+FEFF is EF BB BF as utf-8
print $fh $_ for <DATA>;
close $fh;

__DATA__
a,1
b,2
Š,3
Ž,4
[download]

[reply]
[d/l]

In Section Seekers of Perl Wisdom