Unable to get the SaveAs property of the Workbook class

[Petrini]

Good morning!
Does anyone know how to solve this??

I can access all methods and properties, for example, when I call this:

$worksheet = $output_workbook->Worksheets("Sheet1");
$range = "B3";
echo $worksheet->Range($range)->Value;

It'll show the right value.
But when I call the save method

$output_workbook->SaveAs("C:\test.xls");

it simply doesn't work and I get this error:
"Unable to get the SaveAs property of the Workbook class"

I'm dealing with 3 documents that relate with each other, there's an input excel file, an input word file, and the output excel file (the one which throws the exception)

I noticed when I open the word file, says "A table in this document has become corrupted". I think this may be the problem... but why can I access all the output workbook members except Save and SaveAs?
This seems strange :S
Thanks

[Bob Phillips]

Show the code.

[mdmackillop]

Vista and later will not save to the C:\ root folder. What version are you using?

[Choucha]

Hello everybody,

I think I have the same error on my project.

I am using a COM object in php to comunicate with excel.

Here is my code :

function make_reports($date1,$date2,$lg,$team)
{

$arrd1 = explode('-',$date1);
$arrd2 = explode('-',$date2);

$date1 = $arrd1[2]."-".$arrd1[1]."-".$arrd1[0];
$date2 = $arrd2[2]."-".$arrd2[1]."-".$arrd2[0];


if($date1>$date2)
{
$temp = $date1;
$date1 = $date2;
$date2 = $temp;
}

connectumt();

if($lg=='es')
$sql = "select * from comps_es";
else
$sql="select * from comps";

$res=mysql_query($sql);
$u=0;
while($row = mysql_fetch_row($res))
{
$t = utf8_encode($row[1]);
$compnamearray[$u] = $t;
$u++;
}
$exceltemplate = new COM("Excel.application");
$exceltemplate->Workbooks->Open('C:\ReportFiles_global\ResultsTemplate.xls');

$booktemplate=$exceltemplate->Workbooks(1);
$sheettemplate=$booktemplate->Worksheets(1);

$app = $exceltemplate->Application;
$app->DisplayAlerts = false;
$name = $sheettemplate->name;
echo "<br/>".$name."<br/>";

for($u = 0 ; $u < count($compnamearray);$u++)
{
$col_ = $u +67;
$col= chr($col_);
$cellT=$sheettemplate->Range($col."3");
$temp = utf8_decode($compnamearray[$u]);
$cellT->value=$temp;
}
$col_ ++;
$col= chr($col_);
$cellT=$sheettemplate->Range($col."3");
if($lg=='es')
$temp = utf8_decode('perfil');
else
$temp = utf8_decode('Profile');
$cellT->value=$temp;



$sql = "select * from results";
$res = mysql_query($sql);
//echo "<script>alert(\"hello\")</script>";
$lgn= 4;
while($row = mysql_fetch_row($res))
{
$sql_link = "select * from links where token = '".$row[1]."'";
//echo "<script>alert(\"$sql_link\")</script>";
if($res_link = mysql_query($sql_link))
{
///echo "<script>alert(\"$sql_link\")</script>";
$row_umt = mysql_fetch_row($res_link);
if($row_umt[2] == $team || $team == 0)
{

///////echo "<script>alert(\"$row_umt[2]\")</script>";
//echo "<script>alert(\"$team\")</script>";

connectLS();
$sql = "select distinct * from lime_tokens_48683 t1, lime_tokens_75547 t2 where (t1.token ='".$row[1]."' or t2.token ='".$row[1]."') and t1.token = t2.token and (t1.completed!='N' or t2.completed!='N')";
$resls =mysql_query($sql);
if($rowls = mysql_fetch_row($resls))
{

$t1 = explode(" ",$rowls[10]);
$t2 = explode(" ",$rowls[24]);

$in_range = false;
if (($t1[0]>=$date1 && $t1[0]<=$date2))
{
$in_range = true;
}
if($t2[0]>=$date1 && $t2[0]<=$date2)
{
$in_range = true;
}
if($in_range)
{
$cellT=$sheettemplate->Range("B$lgn");
$temp = utf8_decode($rowls[1]." ".$rowls[2]);
$cellT->value=$temp;
for($u = 0 ; $u < count($compnamearray);$u++)
{
$col_ = $u +67;
$col= chr($col_);
$cellT=$sheettemplate->Range($col.$lgn);
$temp = utf8_decode($row[$u + 2]);
if($temp == '-1')
{
$temp = 'NC';
$cellT->Font->bold = true;
$cellT->Font->ColorIndex=3;
}
$cellT->value=$temp;
}
$col_++;
$col= chr($col_);
$cellT=$sheettemplate->Range($col.$lgn);
$temp = utf8_decode($row[13]);
if($temp == '')
{
$temp = 'NC';
$cellT->Font->bold = true;
$cellT->Font->ColorIndex=3;
}
$cellT->value=$temp;
$cellT->value=$temp;
$lgn++;
}
}
connectumt();
}
}
}
$lgn--;
$cells= $sheettemplate->Range("B3:N$lgn");
$cells->Borders->LineStyle=1;
$cells->Borders->Weight=2.5;
$cells->Borders->ColorIndex=1;

$path = "C:\ReportFiles_global\Report Team ".$team." from ".$date1." until ".$date2.".xls";
echo $path;
$booktemplate->saveas($path);
$app->DisplayAlerts = true;
//Echo " Echo num 5 </br>";
unset($sheettemplate);//Lib?tion de $sheet
unset($booktemplate);//Lib?tion de $book
unset($app);
$exceltemplate->Workbooks->Close();
$exceltemplate->Quit();

unset($exceltemplate);


return $path;


}
?>

When I use this function i get the following message :


Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft Office Excel<br/><b>Description:</b> Unable to get the SaveAs property of the Workbook class' in C:\Program Files\EasyPHP-5.3.2i\www\functions.php:166 Stack trace: #0 C:\Program Files\EasyPHP-5.3.2i\www\functions.php(166): variant->saveas('C:\ReportFiles_...') #1 C:\Program Files\EasyPHP-5.3.2i\www\Reports.php(13): make_reports('01-01-2010', '30-09-2010', 'en', '0') #2 {main} thrown in C:\Program Files\EasyPHP-5.3.2i\www\functions.php on line 166


It also seems that my excel licence is over, is it a "real" issue ?

Thanks in advance :)