Hi,<br>
Recently I'm facing some problems with this parser. My
excel file has some chinese and japanese characters which I'
not able to get correctly into the test file. My code
snippet:<br>
----<br>
<br>
my $oBook =
Spreadsheet::ParseExcel::Workbook->Parse($file); //
correctly instantiated.<br>
my($iR, $iC, $oWkS, $oWkC);<br>
binmode STDOUT, ":utf8";<br>
foreach my $oWkS ( {$oBook->}) { // //
correctly instantiated. <br>
print "----- SHEET: ", $oWkS->,
"n";<br>
for(my $iR = $oWkS-> ;<br>
defined $oWkS-> && $iR <=
$oWkS-> ; $iR++) {<br>
for(my $iC = $oWkS-> ;<br>
defined $oWkS-> && $iC
<= $oWkS-> ; $iC++) {<br>
$oWkC =
$oWkS->[$iR][$iC];<br>
<br>
# there is content in this cell<br>
if($oWkC) {<br>
my $value = $oWkC->Value;<br>
if($value ne "") {<br>
print $value . $sep;<br>
}<br>
}<br>
# oops, no content %&# !?<br>
else {<br>
print $sep;<br>
}<br>
#print "( $iR , $iC ) =>",
$oWkC->Value, "n" if($oWkC);<br>
}<br>
print "n";<br>
}<br>
}<br>
<br>
----<br>
Most of the other lnaguages are supported. Any help is
appreciated.<br>
<br>
The module version<br>
# Spreadsheet::ParseExcel<br>
# by Kawai, Takanori (Hippo2000) 2000.10.2<br>
# 2001. 2.2 (Ver.
0.15)<br>
# This Program is ALPHA version.<br>
<br>
<br>
thanks<br>
To write a respons, access
http://ww
w.cpanforum.com/response_form/3373
To see the full thread, access
http://www.cpan
forum.com/threads/3373
--
You are getting this messages from www.cpanforum.com
To change your subscription information visit http://www.cpanforum.
com/mypan/
|