Hi,
I am attempting to transfer data from a word table to Excel using
Win32::OLE. I am able to do it with the following piece of code, but I am
getting two little boxes after the text in each of the Excel cells. I
presume these are Word formatting characters. How can I filter these out? I
am
I guess these will just be CR/NL characters. You should be able to strip them
in Perl, e.g. with
$wordcell = $tbl-Cell($row,$col)-Range-{Text};
$wordcell =~ s/[\x00-\x1f]//g;
$sheet-Cells($row,$col)-{Value} = $wordcell;
Cheers,
-Jan
From: [EMAIL PROTECTED] [mailto:[EMAIL