[zicon]

Hi,

currently I have PHP running on a windows box (dont ask hehe), basically I have PHP code that "should" be able to read from an excel file.

This is a production box so it has PHP installed, mySQL etc etc ASP /.NET.

Do i need OFfice installed for PHP to be able to read the file?

Or is there something im missing, i've also read somewhere that this shud be enabled by default on Windows PHP installations.

Any help is greatly appreciated.

Wont mean much, but the sorta error im getting is : Did not instantiate Excel

Code:

<?php

// create an object instance
$excel = new COM("Excel.Application") or die("Excel could not be
started");

// pop open the Excel application
$excel->Visible = 1;

// turn off alerts
$excel->DisplayAlerts = 0;

// add a workbook
$excel->Workbooks->Add();

// save 
$excel->Workbooks[1]->SaveAs("D:\\domains\\daniber.com\\wwwroot\\includes\\Test1.xls");

// close the application
$excel->Quit();

$excel = null;

?>

[zicon]

Anyone?

[mikaelf]

yep, you have to install microsoft excel first. note, COM is short for Component Object Model. if you need php to deal with excel, of course you have to have Ms. Excel installed on your winserver, don't you?