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?