PHP and Excel and COM
| From: | Kiz Wong | Date: | Fri, 08 Apr 2005 23:00:58 +0000 |
| Subject: | PHP and Excel and COM | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-212684@lists.php.net to get a copy of this message | ||
Hi,
I am trying to control Excel with PHP via COM.
I am wondering if there are some resources available with all the keywords (I didn't find anything on the net...).
F.i. : I try to modify the content of a textbox in a worksheet.
In VBA, I have:
ActiveSheet.Shapes("Shape1").Select
Selection.Characters.Text = "foo"
If I try it on PHP, I have:
$excel->Workbooks[1]->Worksheets[1]->Shapes["Shape1"]->Characters->Text = "foo";
I get the following error: "Uncaught exception 'com_exception' with message 'Unable to lookup `Characters': Unknown"
Apparently it does not recognize "Characters". What should I use then???
Thanx for your help.
Wongy
_________________________________________________________________
MSN Messenger : discutez en direct avec vos amis ! http://www.msn.fr/msger/default.asp