I am using a HTML form to collect user data ,then put the infomation on the HTML form on a Excel file. Here is my code in PHP :
set_time_limit(0);
error_reporting(E_ALL);
$workbook= "standard_FA_form.xls";
$sheet = "A";
$ex = new COM("Excel.application") or Die ("No Excel is open");
#Get the application name and version
print "Application name:{$ex->Application->value}<BR>";
print "Loaded version: {$ex->Application->version}<BR>";
#Open the workbook that we want to use.
$wkb = $ex->application->Workbooks->Open($workbook) or Die ("Did not open");
$ex->Application->Visible = 1;
#Create a copy of the workbook, so the original workbook will be preserved.
#$ex->Application->ActiveWorkbook->SaveAs("helloWorld.xls");
But there is no excel sheet is shown although I set visible is 1 . Also there is no error message given out and no new excel file is saved.
I can see the following in IE :
Application name:Microsoft Excel
Loaded version: 9.0
What 's the problem with my code and how can I solve it ???
Thank you in advance .
