In the docs it tells me:
"The "looks like" rule is defined by regular expressions:
write_number() if $token is a number based on the following regex: $token =~ /^(+-?)(?=\d|\.\d)\d*(\.\d*)?(Ee(+-?\d+))?$/."
So I changed my code from
$worksheet->write($row, $col++, $_, $format) for @data;
to
for (@data) {
if ($_ =~ m/^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/){
print;
$worksheet->write_number($row, $col++, $_, $format);
}else{
$worksheet->write($row, $col++, $_, $format)
}
}
It never printed, so it might be a glitch in the "looks like" rules?
Cheers, jonix
|