A very funny problem

phpfreak1

Hi everybody,

I got a very funny problem.

You see it is quite easy to open a xls file like this:

$data->read('525.xls');

But then it would be nice to open a number of xls files.

for($r=$start; $r<=$end; $r++) {

$xls = (string) $r ."&#46". "xls";
$data->read($xls);

//other stuff...

}

Then I get this little message on screen: "The filename 525.xls is not readable:-)"

This ' ' seems important.

//PHPfreak
Lund Sweden

Drakla

Change

$xls = (string) $r ."&#46". "xls";
to
$xls = (string) $r . ".xls";

What are you using to read the xls files?

phpfreak1

Thank you very much it worked! Such a simple solution.

I am using spread sheet excel reader.

It works pretty good.

Drakla

Is the reader free, and if so do you have a link to it, as somebody else on here wants to do some php + Excel stuff.

Cheers.

phpfreak1

I got it from here:

http://sourceforge.net/projects/phpexcelreader/

I think it is free, but I am not sure.

Yours in PHP

Niel_Roos

Hey there guys. This is actually my first post. I am having the same problem though. Here is my code:

function upload_excel($file)  {

  require_once("Excel/excel_reader2.php");

  $data = new Spreadsheet_Excel_Reader();
  $data->read($file);

  $serial_used = array(); 
  $serial_active = array();  

  $count = 1;  

  while($data->val($count,'L') != '')  { 
    if ($data->val($count,'L')=='Card is Active')  {
      array_push($serial_active, $data->val($count,'A'));
    }
    else  

      array_push($serial_used, $data->val($count,'A'));
    $count++;
  }