Description: ------------ Hello, I could install Spreadsheet_Excel_Writer easily with Apache on several Windows, but on Windows server 2008 with IIS7 it has never worked. Actually, I've checked carefully my IIS7 configuration (FastCGI is enable), but every .xls which are generated are empty. Test script: --------------- C:\Sites\>pear install Spreadsheet_Excel_Writer PHP_PEAR_INSTALL_DIR is not set correctly. pearcmd.php could not be found there. Please fix it using your environment variable or modify the default value in pear.bat The current value is: C:\Sites\/PEAR C:\Sites\> Expected result: ---------------- The test file below writes one word in a base.xls file with Apache, but with IIS7 it doesn't: <?php error_reporting( E_ALL & ~E_NOTICE & ~E_DEPRECATED ); set_time_limit(300); set_include_path ("PEAR/"); include 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer(); $workbook->setTempDir('./tempdoc'); $workbook->send('base.xls'); $worksheet = $workbook->addWorksheet(); $worksheet->write(1,2,'test'); $workbook->close(); $workbook->sendFile(); ?>

PS: I've replaced this path "C:\Sites\/PEAR" by a good one "C:\Sites\PEAR" in all the subdirectories without success too.

FInally I've solved the problem by replacing the old syntax: $workbook->send($File); by: $workbook->setTempDir('../Temp'); //The directory should exist $workbook->send($File); $workbook->close(); $workbook->sendFile();