it's strange if I do the same code in a XLSX file, I have an error on accent.

XLSX files contain XML files, and assuming Excel is writing them correctly, these encoding issues should hopefully not arise. In other words, the strings you get should not need the extra decode step, and that line in my code could be changed to my $val = $sheet->{cell}[$c][$r];.

I would like to convert MacRoman in HTML é --> & eacute

As I said and as haj explained some more, this doesn't really make sense in the context of XML, only in HTML, but you haven't explained how you want to integrate the two. I think the best thing would be if you could show an example of exactly what the output file should look like. Note that even in HTML, if the encoding is declared correctly, you don't even need escapes like é.

In reply to Re^5: Help encode_entities doesn't seem to work by haukex
in thread [SOLVED] -Help encode_entities doesn't seem to work by Balawoo

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.