Re: XLSX to CSV with high ASCII characters

[poj]

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: $!";

poj

[apu]

That outputs

Nicolás,123

[poj]

It that what it shows in Excel ?

poj

[apu]

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