Help with COM
| From: | Ethan Nelson | Date: | Tue, 28 Oct 2003 22:12:46 +0000 |
| Subject: | Help with COM | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-21914@lists.php.net to get a copy of this message | ||
Hello,
I am trying to write some excel functions in PHP 4.3.3 using the COM interface. The objective it to
create a "BottomEdge" border with regular line styles etc... The actual visual basic code
that the macro recorder in excel writes goes as follows:
Range("A13:E13").Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Now my code is in object and looks something like:
$this->sheet->column->EntireColumn->Font->Bold=true;
That would be an example of how I would make an entire column bold (I think). Anyway... how the
heck do I do a "with" statement using this PHP syntax? I tried separating each line into
objects but tells me it can't find function "Border":
$range = $this->sheet->Range("A13:E13");
$selection = $range->Select;
$diagdown = $selection->Borders(xlDiagonalDown);
$diagdown->LineStyle = xlNone;
...
with?
Thanks for the help... I'm pretty new at trying to translate VB syntax into a compatible PHP
code.
-Ethan Nelson,
Modulus, LLC