so, i've read data in from a spreadsheet, assign it to a 3d array and i need
to output another spreadsheet with worksheets that are named like one of the
cell of the first. however, when i do i get this:
Invalid character []:*?/\ in worksheet name: M/V AUTO ATLAS at ./
xldatesel.pl line 93

ok, find, so i do this:
my $name = $xldata[ $row ][ 14 ] =~ tr/[^A-Za-z0-9]//d;

so, then i get this:
Worksheet name '10', with case ignored, is already in use at
./xldatesel.plline 93

i'm actually printing out the results of $name and i'm seeing numbers from 8
to about 15. it seems to be giving me the string length and not the name.
wtf?

Reply via email to