Hello,
i am using the parseexcel module to gather data from certain cells in Excel spreadsheets and today is the 1st time I am having trouble with it. There are certain cells that come up like this: '\0A\0n\0i\0m\0e\0r\0 \0a\0v\0e\0c\0 \0d \0a\0u\0t\0r\0e\0s\0 \0m\0e\0t\0h\0o\0d\0e\0s\0 \0q\0u\0e\0 \0l \0e\0x\0p\0o\0s\0e' although the text is clear in the cell, like this: 'Animer avec d autres methodes que l expose'.
Code:
[...]
elsif ($iC == 1) {
$course_title = $oWkC->{Val};
$course_title =~ s/\s+$//; # remove eventually trailing whitespaces
$course_title =~ s/^\s+//; # remove eventually leading whitespaces
[...]
