#19 Patch, Excel files generated by Crystal

[Jenkky]

The Reader cannot read Excel files generated by Crystal Reports. The reason is that the Reader searches for the text string "workbook" in the file, even though in the Excel the "workbook" string is with CAPS. So add this to oleread.inc:

CHANGE THIS LINE:
if (($name == "Workbook") || ($name == "Book")) {

TO:

if (($name == "Workbook") || ($name == "Book") || ($name == "WORKBOOK")) {

But then, the Reader fetches only numbers and dates..So you need to change the encoding in read.php:

$data->setOutputEncoding("GB2312");
$data->setUTFEncoder('mb');

Even though Mozilla cannot show scandinavian characters (Å, Ä, Ö are shown as ?Å, ?Ä, ?Ö), this worked quite well for me, but you may need to change the encoding to something else. If someone has a solution for the Mozilla problem, please tell me.

[Jenkky]

Logged In: YES
user_id=1943177
Originator: YES

Update:
To read Scandinavian characters and fix the bug for Mozilla described above, use
$data->setOutputEncoding('ISO-8859-1');
instead of the OutputEncoding above.

If you still can't read the Crystal file, add this line to oleread.inc:
if ($name == "Root Entry" || $name == "ROOT ENTRY") {
instead of
if ($name == "Root Entry") {

//Jenkky