Re: InsertSheetFromFile

Michael Jeier wrote:
> I tried the parameters "Name",
"Index", "URL" and some more, but they 
> didn't
> work.
> I'm not sure, but could it be 3 parameters? The file,
the position to 
> insert
> and the
> sheet which shoud be inserted. Is there maybe another
solution to insert a
> table into another sheet?

The arguments are for inserting a new (empty) sheet, and
"Name" is the 
sheet's new name. You can't insert a sheet from another file
using this 
slot.

The easiest way to insert a sheet from a file is to insert
an empty 
sheet, then use XSheetLinkable's link method to link it to
your source 
data, and then remove the link again. The data will still be
there.

Niklas

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org

Hi,

Thx for the answer, is it possible to copy the NamedRanges
of a table too?

Regards, Michael

On 4/2/07, Niklas Nebel <Niklas.Nebelsun.com> wrote:
>
> The arguments are for inserting a new (empty) sheet,
and "Name" is the
> sheet's new name. You can't insert a sheet from another
file using this
> slot.
>
> The easiest way to insert a sheet from a file is to
insert an empty
> sheet, then use XSheetLinkable's link method to link it
to your source
> data, and then remove the link again. The data will
still be there.
>
> Niklas
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
> For additional commands, e-mail: dev-helpapi.openoffice.org
>
>