Hi abhijit
Thanx for response its working.
On Wed, May 28, 2008 at 9:53 AM, abhijit murade <abhijitmurade@xxxxxxxxx>
wrote:
> 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 <malayappa%40nannacomputers.com>>
> 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><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><php-objects%
> > 40yahoogroups.com> [mailto:
> > > php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com><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><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>
> > <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]
>
>
>
--
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]
