Re: [PHP-WIN] Excel OLE Automation using COM: file access problem

-- >>> 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 &

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 : >> >>

[PHP-WIN] Excel OLE Automation : accessing the Excel constants

Hi, I'm confronted to a new problem with Excel Automation: I don't manage to access the constants. For example, I want to find the last cell in a column: ExcelSheet.Range("C65536").End(xlUp) This fails because the constant xlUp is undefined... There is some user contributed notes about that pr

RE: [PHP-WIN] Excel OLE Automation using COM: file access problem

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

Re: [PHP-WIN] Excel OLE Automation using COM: file access problem

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

RE: [PHP-WIN] Excel OLE Automation using COM: file access problem

> 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 >

Re: [PHP-WIN] Excel OLE Automation using COM: file access problem

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

[PHP-WIN] Excel OLE Automation using COM: file access problem

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 under another name and closes Excel:

[PHP-WIN] excel tables to mysql tables

I have 4500 records in excel tables waiting to be insert into mysql structure did anyone done this before i need it so much.. Kerem Arslanlı İstanbul Technical University UEPRC -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-WIN] Excel Spreadsheet as a datasource

, 2003 2:57 PM Subject: [PHP-WIN] Excel Spreadsheet as a datasource Has anyone successfully used an Excel spreadsheet as a datasource? I realize that it is a flimsy datasource but I have a need to quickly and dynamically take the information stored in spreadsheets and manipulate the data and write

RE: [PHP-WIN] Excel Spreadsheet as a datasource

tcuban.com -Original Message- From: Herhuth, Ron [mailto:[EMAIL PROTECTED] Sent: 18 March 2003 13:57 To: [EMAIL PROTECTED] Subject: [PHP-WIN] Excel Spreadsheet as a datasource Has anyone successfully used an Excel spreadsheet as a datasource? I realize that it is a flimsy datasource

Re: [PHP-WIN] Excel Spreadsheet as a datasource

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

[PHP-WIN] Excel Spreadsheet as a datasource

Has anyone successfully used an Excel spreadsheet as a datasource? I realize that it is a flimsy datasource but I have a need to quickly and dynamically take the information stored in spreadsheets and manipulate the data and write them to a SQL database. I would be grateful for any assistance

Re: [PHP-WIN] Excel

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

[PHP-WIN] Excel

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 ? Ing. Daniel Šichta EIF AS TIS SWH s.r.o. Bytčická 2 010 01 Žilina tel.: +421 41 505 5889 fax: +421 41 505 5809

Re: [PHP-WIN] Excel not closing after using it via COM

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

Re: [PHP-WIN] Excel not closing after using it via COM

> 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

RE: [PHP-WIN] Excel not closing after using it via COM

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

Re: [PHP-WIN] Excel not closing after using it via COM

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

RE: [PHP-WIN] Excel not closing after using it via COM

E-mail) > Subject: RE: [PHP-WIN] Excel not closing after using it via COM > > > 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 [m

RE: [PHP-WIN] Excel not closing after using it via COM

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&

RE: [PHP-WIN] Excel not closing after using it via COM

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

Re: [PHP-WIN] Excel not closing after using it via COM

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

RE: [PHP-WIN] Excel not closing after using it via COM

[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 > > >

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

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 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

Re: [PHP-WIN] Excel not closing after using it via COM

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

RE: [PHP-WIN] Excel not closing after using it via COM

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

RE: [PHP-WIN] Excel not closing after using it via COM

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);

RE: [PHP-WIN] Excel not closing after using it via COM

lto:[EMAIL PROTECTED]] >Sent: Tuesday, April 23, 2002 4:40 PM >To: Php-Win (E-mail) >Subject: [PHP-WIN] Excel not closing after using it via COM > >After working with Excel via COM, i cannot seem to get >the instance of Excel to quit (CTL+ALT+DEL shows an >'EXCEL.EXE' i

RE: [PHP-WIN] Excel not closing after using it via COM

: 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.. > >

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.. -Original Message- From: Scott Hurring [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 4:40 PM To: Php-Win (E-mail) Subject

[PHP-WIN] Excel not closing after using it via COM

After working with Excel via COM, i cannot seem to get the instance of Excel to quit (CTL+ALT+DEL shows an 'EXCEL.EXE' in my process list). The script opens up a file, puts some numbers in, adds some numbers up, then closes the sheet and tells excel to exit. I've been trying for a few hours now

Re: [PHP-WIN] Excel COM

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

Re: [PHP-WIN] Excel COM

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

[PHP-WIN] Excel COM

I am trying to use the excel Com on a win2k/IIS5/php4.0.4pl1 with Office 2K SR-1. I keep getting the following error. Warning: Unable to obtain IDispatch interface for CLSID {00020820---C000-0046}: Not enough storage is available to complete this operation. in c:\Inetpub\wwwroot/

RE: [PHP-WIN] Excel Manipulation

[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 2:16 PM To: [EMAIL PROTECTED] Subject: [PHP-WIN] Excel Manipulation If I have an excel document I created dynamically and after every 8 records I want it to automatically want to print. Is there a way to do this in PHP or some other language.

[PHP-WIN] Excel Manipulation

If I have an excel document I created dynamically and after every 8 records I want it to automatically want to print. Is there a way to do this in PHP or some other language. Ryan Conover -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional