Hi Rob
Thanx or u r response. fallowing is the code .when i exectue this code .
code is executing up to 8 line only
i.e printing the file name only . After 8 line code is not executing.
1) $filename = "Customer.xls";
2)$sheet1 = 1;
3)$arr=array(1=>'a','b','c','d','e');
4)$sheet2 = "sheet2";
5)$excel_app = new COM("Excel.application") or Die ("Did not connect");
6)print "Application name: {$excel_app->Application->value}<br>\n" ;
7)print "Loaded version: {$excel_app->Application->version}<br>\n";
8)print "file name is".$filename."<br>";
//$excel_app->Application->Visible = 1; #Make Excel visible.
$Workbook = $excel_app->Workbooks->Open($filename) or Die("Did not open
$filename $Workbook");
$Worksheet = $Workbook->Worksheets($sheet1);
echo "MALAYAPPA<br>";
$Worksheet->activate;
$excel_cell = $Worksheet->Range("C1");
$excel_cell->activate;
for($i=1; $i<=5;$i++)
{
for($j=1; $j<=5;$j++)
{
$excel_cell = $Worksheet->Range($arr[$i].$j);
echo "<br> The value is $arr[$i].$j => ". $excel_cell->value;
}
}
$excel_result = $excel_cell->value;
$Workbook->Close;
unset($Worksheet);
unset($Workbook);
$excel_app->Workbooks->Close();
$excel_app->Quit();
unset($excel_app);
Thnx & Regards
malayappa
On Tue, May 27, 2008 at 4:04 PM, Atkinson, Robert <ratkinson@xxxxxxxxxxxxx>
wrote:
> The PHP Classes website (http://phpclasses.fonant.com/browse/) has a
> number
> of Excel readers/writers that you should take a look at.
>
> Rob.
>
> -----Original Message-----
> From: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com> [mailto:
> php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>] On
> Behalf Of malayappa2000
> Sent: 23 May 2008 05:48
> To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>
> Subject: dll for creating instance of COM object in PHP 5.2.5
>
> Hi Guys
>
> We have a requirement reading data from Excel sheet and storing in
> database.is there is a way to read data from Excel sheet and Storing
> them. In to databse
>
> We Identified tht throw COM this will take place
> and what dll we need to use for Create Instance for COM object we are
> using PHP5.2.5
>
> Thax&Regards
> malayappa
>
>
> ***********************************************************************************
> Any opinions expressed in email are those of the individual and not
> necessarily those of the company. This email and any files transmitted with
> it are confidential and solely for the use of the intended recipient
> or entity to whom they are addressed. It may contain material protected by
> attorney-client privilege. If you are not the intended recipient, or a
> person responsible for delivering to the intended recipient, be advised that
> you have received this email in error and that any use is strictly
> prohibited.
>
> Random House Group + 44 (0) 20 7840 8400
> http://www.randomhouse.co.uk
> http://www.booksattransworld.co.uk
> http://www.kidsatrandomhouse.co.uk
> Generic email address - enquiries@xxxxxxxxxxxxxxxxx<enquiries%40randomhouse.co.uk>
>
> Name & Registered Office:
> THE RANDOM HOUSE GROUP LIMITED
> 20 VAUXHALL BRIDGE ROAD
> LONDON
> SW1V 2SA
> Random House Group Ltd is registered in the United Kingdom with company No.
> 00954009, VAT number 102838980
>
> ***********************************************************************************
>
>
>
--
Regards
P.M.M.Srinivas
jr Software Engineer
ID: NGH32053
Ph : +91 9849426596
Home page : www.nannacomputers.com
An ISO 9001:2000 company
[Non-text portions of this message have been removed]
