hi malayappa,
try to give absolute path to open method
$excel_app->workbooks->Open("D:\abhijit\php_webroot\example\DR40-Queries.xls")
it will work.
On Wed, May 28, 2008 at 9:15 AM, srinivas pmm <malayappa@xxxxxxxxxxxxxxxxxx>
wrote:
> 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<ratkinson%40tbs-ltd.co.uk>
> >
> 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><php-objects%
> 40yahoogroups.com> [mailto:
> > php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com><php-objects%
> 40yahoogroups.com>] On
> > Behalf Of malayappa2000
> > Sent: 23 May 2008 05:48
> > To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com><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>
> <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]
>
>
>
--
Thanks & Regards,
[Non-text portions of this message have been removed]
