
Robert Sevcik - 2004-12-21 08:04:20 -
In reply to message 1 from zxgcm
Hi,
First, you should run on WINDOWS (I realy don't know if it is possible on LINUX) and have the COM object properly installed. May be you'll have to configure COM permissions for the user that PHP runs under (run dcomcnfg).
Then get an object api reference for the object you are going to use (excel.application, OWC10.SpreadSheet...) from the M$ web or from wherever it is installed.
Then just use PHPs COM extension to call COM object methods and to get and set its properties.
Better choice for COM is PHP5 which has better support, but with PHP4 it is possible as well.
A little example, just to verify that it's working (MS excel installed and accessible):
$oExcel = new COM("Excel.Application") or Die ("Did not instantiate Excel");