Excel problems.

[mirba]

I've some problem in extracting the date with the code below. The column with the date is returned in a strange format (something like "10714656400")

Any suggestion?

$excel = new COM("Excel.Application");
$excel->Workbooks->open("C:\calendario.xls");
$book = $excel->ActiveWorkbook;
  while ($cell->Value != " ")
        { 
          while ($colonna<=$fine) 
	      { 
        $cell = $excel->ActiveWorkbook->Worksheets[1]->Cells($riga,$colonna); 
	    $cell->Activate();

       echo  "<td>";
	   echo $cell->Value ;
	   echo  "</td>";

    $colonna++;
      } 


$book->Close();
unset($book);

$excel->Quit();
$excel->Release();
unset($excel);
...

[weekender]

that's a unix timestamp - see [man]date[/man]

[mirba]

Thanks so much. 😃