Trying to display contents of sheet 1 in excel workbook

[farkewie]

Hello i am trying to convert the below code to display the fullcontents of a excel sheet. with the same layout as if i were looking in excel at it.

 

old code

 

<?php

$strSheetName = 'Sheet1';
$strCellName = 'A1';

$objXLApp = new COM( "excel.application" ) or die( "unable to start
MSExcel" );
$objXLApp->Workbooks->Open( "test.xls" );
$objXLSheet = $objXLApp->ActiveWorkBook->WorkSheets( $strSheetName );
$objXLCell = $objXLSheet->Range( $strCellName );

print "Cell $strCellName in $strSheetName: \"" . $objXLCell->Value() .
"\"\n";

// must do all of these to release resources correctly...

unset( $objXLCell );
unset( $objXLSheet );

$objXLApp->ActiveWorkBook->Close();
$objXLApp->Quit();

unset( $objXLApp );

?>

 

my new code

 

 

<?php

$strSheetName = 'Sheet1';
$strCellName = 'A1';

$objXLApp = new COM( "excel.application" ) or die( "unable to start
MSExcel" );
$objXLApp->Workbooks->Open( "test.xls" );
$objXLSheet = $objXLApp->ActiveWorkBook->WorkSheets( $strSheetName );
$objXLCell = $objXLSheet->Range( $strCellName );

print $objXLSheet;

// must do all of these to release resources correctly...

unset( $objXLCell );
unset( $objXLSheet );

$objXLApp->ActiveWorkBook->Close();
$objXLApp->Quit();

unset( $objXLApp );

?>

 

error

 

 

Catchable fatal error: Object of class variant could not be converted to string in F:\Documents\public_html\mobiles\xl.php on line 12