--
>>> From: Richard Quadling [mailto:rquadl...@googlemail.com]
>>> Sent: Tuesday, May 19, 2009 5:28 PM
>>> To: Faubry, Samuel
>>> Cc: php-windows@lists.php.net
>>> Subject: Re: [PHP-WIN] Excel OLE Automation using COM: file
>>> access problem
&
; To: Faubry, Samuel
>> Cc: php-windows@lists.php.net
>> Subject: Re: [PHP-WIN] Excel OLE Automation using COM: file
>> access problem
>>
>> 2009/5/19 Faubry, Samuel :
>> >> From: Richard Quadling
>> >> 2009/5/18 Faubry, Samuel :
>> >>
your documentation is more reliable.
Thanks,
Samuel
> -Original Message-
> From: Richard Quadling [mailto:rquadl...@googlemail.com]
> Sent: Tuesday, May 19, 2009 5:28 PM
> To: Faubry, Samuel
> Cc: php-windows@lists.php.net
> Subject: Re: [PHP-WIN] Excel OLE Aut
2009/5/19 Faubry, Samuel :
>> From: Richard Quadling
>> 2009/5/18 Faubry, Samuel :
>> > Hi,
>> >
>> > I am interfacing PHP and Excel to build a web-based
>> reporting tool. I am running IIS6.0 with PHP 5.2.5 on Windows
>> Server 2003, with Office 2003 installed.
>> >
>> > For testing purpose, I wro
> From: Richard Quadling
> 2009/5/18 Faubry, Samuel :
> > Hi,
> >
> > I am interfacing PHP and Excel to build a web-based
> reporting tool. I am running IIS6.0 with PHP 5.2.5 on Windows
> Server 2003, with Office 2003 installed.
> >
> > For testing purpose, I wrote a script that just connects to
>
2009/5/18 Faubry, Samuel :
> Hi,
>
> I am interfacing PHP and Excel to build a web-based reporting tool. I am
> running IIS6.0 with PHP 5.2.5 on Windows Server 2003, with Office 2003
> installed.
>
> For testing purpose, I wrote a script that just connects to Excel, opens a
> workbook, saves it
Hi there is commercial product out there if your company can afford it it is
quite nice : http://www.zakkis.ca/products/abc_lightparser/index.php
Erwan
- Original Message -
From: "Herhuth, Ron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 18, 2003 2:57 PM
Subject: [PHP
I've used COM objects to write to Excel spreadsheets and had no-end of
problems. But never tried reading from it, well, did minimal reading to
find the next blank cell, so I guess it would be much the same. It's
pretty simple stuff using the COM object to access it tho.
chris kranz
fatcuban.com
Hello, Ron,
I tried the same a couple of months ago, but received a message like
"Cannot find the table in datasource". Obviously the ODBC driver in
Win98/2000 couldn't find the sheet and resolve it as a table.
Regards, Veselina
At 08:57 3/18/03 -0500, Herhuth, Ron wrote:
>
>Has anyone successful
At 1/30/2003 08:47 AM, you wrote:
Hi,
cfg: IIS 5.1, php4.1.2
After submiting web form I'm creating Excel file on server. Then I need to
show it in client browser. How can I do it ?
Have the client use IE as their browser and put this at the beginning of
the module
header("Content-Type: applic
This way you only have one errant
instance and not hundreds.
Alan.
- Original Message -
From: "Neil Lincoln" <[EMAIL PROTECTED]>
To: "Alan Brown" <[EMAIL PROTECTED]>; "Scott Hurring" <[EMAIL PROTECTED]>;
"Php-Win (E-mail)" <[E
> Is temporary-object behaviour supposed to happen
> in cases like $obj->another->func(), or is this
> an unintended side-effect of something else?
no side effect, happens each time you dereference more than one member.
$obj->foo->bar->func();
will therefore create two temp objects.
>
> Does P
GREAT!
-Original Message-
From: Alan Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 3:24 PM
To: Scott Hurring; Php-Win (E-mail)
Subject: Re: [PHP-WIN] Excel not closing after using it via COM
Not intended behaviour. A fix has been checked into CVS already.
- Original
Not intended behaviour. A fix has been checked into CVS already.
- Original Message -
From: "Scott Hurring" <[EMAIL PROTECTED]>
To: "Php-Win (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, April 26, 2002 16:08
Subject: RE: [PHP-WIN] Excel not closing aft
ailto:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2002 8:00 AM
> To: Scott Hurring; Php-Win (E-mail)
> Subject: Re: [PHP-WIN] Excel not closing after using it via COM
>
> There is a missing "Release" call in the COM code when
> temporary objects are
> created for a co
ott Hurring
Systems Programmer
EAC Corporation
[EMAIL PROTECTED]
Voice: 201-462-2149
Fax: 201-288-1515
> -Original Message-
> From: Alan Brown [mailto:[EMAIL PROTECTED]]
> Subject: Re: [PHP-WIN] Excel not closing after using it via COM
>
> There is a missing "Release&
We have tried this and it doesn't help. And yes, any non normal exit from
the EXCEL COM object results in a "zombie".
-Original Message-
From: Alan Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 8:00 AM
To: Scott Hurring; Php-Win (E-mail)
Subject: Re: [PHP
rom: "Scott Hurring" <[EMAIL PROTECTED]>
To: "Php-Win (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, 25 April, 2002 13:51
Subject: RE: [PHP-WIN] Excel not closing after using it via COM
> I'm not doing this through Apache.
>
> I tried out Win32 command l
[EMAIL PROTECTED]
Voice: 201-462-2149
Fax: 201-288-1515
> -Original Message-
> From: Neil Lincoln [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 25, 2002 1:20 PM
> To: Scott Hurring; Php-Win (E-mail)
> Subject: RE: [PHP-WIN] Excel not closing after using it via COM
>
>
>
lto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 11:59 AM
To: Php-Win (E-mail)
Subject: RE: [PHP-WIN] Excel not closing after using it via COM
I went back and ran some perl code using the
Excel COM object. Excel does properly exit...
so it looks like you are correct -- it's
probably a bug in
I went back and ran some perl code using the
Excel COM object. Excel does properly exit...
so it looks like you are correct -- it's
probably a bug in PHP's COM code.
Attached is is sample Perl, PHP and Excel,
if anyone wants to verify that excel does
indeed die after the perl script is finished
On Wed, 24 Apr 2002 17:28:32 -0400, you wrote:
>Thanks for the suggestion. I tried using SaveAs(...) in
>addition to Save(), to no avail. Excel still stays resident.
>
>This is my "end" sequence, when i'm all done processing
>the spreadsheet. Can anyone see any flaws or errors in
>what i'm doi
At 05:28 PM 4/24/02 -0400, Scott Hurring wrote:
>This is my "end" sequence, when i'm all done processing
>the spreadsheet. Can anyone see any flaws or errors in
>what i'm doing ??
>
>$book->Save();
>$book->Close();
Try
$book->Close("False");
>I agree with a previous poster to this l
Thanks for the suggestion. I tried using SaveAs(...) in
addition to Save(), to no avail. Excel still stays resident.
This is my "end" sequence, when i'm all done processing
the spreadsheet. Can anyone see any flaws or errors in
what i'm doing ??
$book->Save();
$book->Close();
unset($sheet);
Not sure if this will help or not, but I had a similar issue using Perl.
Turns out that it was popping up a dialog box on the server when
I did a save or saveas and there was a pre-existing file with that
same name. I solved it by first deleting the file, then doing a
saveas and the problem wen
: Scott Hurring; Php-Win (E-mail)
> Subject: RE: [PHP-WIN] Excel not closing after using it via COM
>
>
> I spent many hours on this and gave up and added a process
> kill for the
> EXCEL "zombie" after exiting the COM code.
> There must be a better way..
>
>
I spent many hours on this and gave up and added a process kill for the
EXCEL "zombie" after exiting the COM code.
There must be a better way..
-Original Message-
From: Scott Hurring [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 4:40 PM
To: Php-Win (E-mail)
Subject: [PHP-WIN] E
I have also had such errors when using COM objects in general. I have not
been able to pinpoint exactly the cause, but it seems that using any COM
object in invisible mode ( setting the visible property to fasle) will
increase your chances of failure. You also may find that you simply will not
hav
Ryan:
Hey I am going to just say that I am curious myself now
So that is why I am posting to this group
Thanks
Mike
""Conover, Ryan"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am trying to use the excel Com on a win2k/IIS5/php4.0.4pl1 with Office
2
You can check the number of written rows every so often, see the COM class
Excel at:
http://phpclasses.upperdesign.com/browse.html?package=86
Message from Alain Samoun
[EMAIL PROTECTED]
HEAR ME>> http://pagoo.com/signature/alain
-Original Message-
From: Conover, Ryan [mailto:[EMAIL PR
30 matches
Mail list logo
