in reply to XLSX to CSV with high ASCII characters

Does this work ?

#!/usr/bin/perl
use strict;
use Text::CSV;
my $outputFile = 'bar.csv';
my $csv = Text::CSV->new ( { binary => 1, eol => "\n" } )
                or die "Cannot use CSV: ".Text::CSV->error_diag ();
open my $fh, ">:encoding(utf-8)", $outputFile
    or die "$outputFile: $!";
$csv->print ($fh, ['Nicolás',123]);
close $fh or die "$outputFile: $!";

[download]
poj

Replies are listed 'Best First'.
Re^2: XLSX to CSV with high ASCII characters
by apu (Sexton) on Aug 26, 2017 at 19:39 UTC
    That outputs 
    Nicolás,123
[reply]

      It that what it shows in Excel ?

      poj
[reply]

        Excel shows Nicholás properly, as does the CSV/text output of xls2csv. But my script, and your test script, both create output with á as á

        And, if I open bar.csv in Excel, I get Nicolás

        $ cat bar.pl
#!/usr/bin/perl
use strict;
use Text::CSV;
my $outputFile = 'bar.csv';
my $csv = Text::CSV->new ( { binary => 1, eol => "\n" } )
                or die "Cannot use CSV: ".Text::CSV->error_diag ();
open my $fh, ">:encoding(utf8)", $outputFile
    or die "$outputFile: $!";
$csv->print ($fh, ['Nicolás',123]);
close $fh or die "$outputFile: $!";

$ cat bar.csv
Nicolás,123

        [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom