Here's a command-line script I posted a long time ago: xls2tsv -- it's so old it still uses Spreadsheet::ParseExcel (i.e. it assumes the old "xls" format rather than "xlsx"), but apparently, you are already using a module that handles your particular Excel spreadsheets, so the basic point that is relevant here is:

my $xl = Spreadsheet::ParseExcel->new;  # or whatever module/version w
+orks
my $wb = $xl->Parse( $filepath ) or die "$filepath: $!\n";

for my $sheet ( @{$wb->{Worksheet}} ) {
    $sheet->{MaxRow} ||= $sheet->{MinRow};
    for my $row ( $sheet->{MinRow} .. $sheet->{MaxRow} ) {
        $sheet->{MaxCol} ||= $sheet->{MinCol};
        for my $col ( $sheet->{MinCol} .. $sheet->{MaxCol} ) {
            my $cell = $sheet->{Cells}[$row][$col];
            my $val = $cell->{Val};

            if ( $cell->{Code} eq 'ucs2' ) {
                $val = decode( "UTF-16BE", $val );

                if ( $val =~ /\p{Han}/ ) {
                    # this cell contains Chinese characters
                }
                # NB: there may be non-ASCII Unicode characters that a
+re not Chinese
            }
        }
    }
}
[download]

---

---

• 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.