Help with .Add specification

[Norman Peelman]

Hi group,

I'm using PHP5 to program Excel vie COM interface and have run into a snag
( for me anyway ). I am trying to use the .Add method on a Worksheet and
can't figure out the following:

From microsoft: (optional are 'Before, After, Count, Type)
ActiveWorkbook.Sheets.Add Before:=Worksheets(Worksheets.Count)


turns into PHP:
$this->excel->Worksheets->Add()

except I don't know how to specify 'Before, After, Count, Type' as options.?
It will accept one 'sheet obj' as an argument such as:

$this->excel->Worksheets->Add($this->excel->Worksheets(2))
but how do I specify if it's 'Before' or 'After' as well as 'Count' and
'Type'?

This doesn't work for me: (pseudo VB style)
$this->excel->Worksheets->Add(Before:=??, After:=??, Count:=??,
Type:=xlWorksheet)

Can anyone point me in the right direction?

Thanks,
Norman

 

[Bob Phillips]

Norman,

Is it as simple as enclosing those parts in parentheses (brackets), making
sure that they are fully qualified?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Norman Peelman]

Norman,

Is it as simple as enclosing those parts in parentheses (brackets), making
sure that they are fully qualified?

--

Bob,

I guess I don't understand the 'qualification'. I have tried many
different ways and can only get one argument to pass in. Maybe if someone
could provide a C/C++ example using all four parameters? If all else fails I
can program around it by doing externally what Excel is doing internally.
Sorry if this is off topic.

Thanks,

Norman

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Norman,

By fully qualified, I mean make sure that each object has an application,
workbook, worksheet , etc., identifier.

--

HTH

RP
(remove nothere from the email address if mailing direct)

Norman,

Is it as simple as enclosing those parts in parentheses (brackets), making
sure that they are fully qualified?

--

Bob,

I guess I don't understand the 'qualification'. I have tried many
different ways and can only get one argument to pass in. Maybe if someone
could provide a C/C++ example using all four parameters? If all else fails I
can program around it by doing externally what Excel is doing internally.
Sorry if this is off topic.

Thanks,

Norman

 

[Norman Peelman]

Norman,

By fully qualified, I mean make sure that each object has an application,
workbook, worksheet , etc., identifier.

--

Well, I thought I did. I have tried by setting up separate variables for
each:

$Before = sheet_obj;
$After = sheet_obj;
$Count = integer number;
$Type = xlWorksheet; // I have all the constants defined through the COM
object

I guess the question becomes: If both 'Before' and 'After' are sheet objects
and are optional, how does the function receive the arguments?

ActiveWorkbook.Sheets.Add Before:=Worksheets(Worksheets.Count)

I assumed that 'Before:=' is a variable assignment of some sort. How is the
'Worksheets(??)' object actually being passed to the function that indicates
it is the 'Before' property? How is 'Before' being sent to the function?

I would assume that:

ActiveWorkbook.Sheets.Add Before:=Worksheets(4) After:=Worksheets(2)
Count:=2 Type:=xlWorksheet

would insert 2 new worksheets somewhere After 2 and Before 4
but I can't figure out how the assignments are being handled.

Thanks again,

Norm