Click to See Complete Forum and Search --> : PHP COM Permission/resource problem


sklarenbach
04-27-2005, 03:17 PM
Hello,

I'm using PHP 5.0.3 and Windows 2003 Server.

I'm opening an excel spreadsheet through PHP using COM, and then saving it as a tab delimited text file.

It works the first time, I upload the file to the server, and initiate COM, open the workbook and save it as a (tab) txt file.

The problem is, I can't seem to delete the files after without a reboot of the server. This poses a problem if the user tries to reupload the same file again, as the script times out and/or crashes.

I'm sure it's a permission problem, but I don't know COM very well so any help is appreciated.

here's my code

$excel = new COM("Excel.application") or die ("excelreader: constructor");

$workbook = $excel ->application->Workbooks->Open($path);

$newFile = substr($path, 0, -3) .'txt'; //strip extension and add a text one

$wkb->SaveAs($newFile, -4158); //I don't know that -4158 is the right parameter, it may be the problem (ie, read only), but it's the only one I could find that would save the file as a tab delimited text file

//these calls don't work, the system hangs when it tries to close the workbook or quit the excel app
$wkb->Close("False");
$excel ->Quit();

Thanks for you help