It's true that Excel has that useful capability. The best workaround for Oo is
to import the external data to the new sheet, copy it, paste it where you want
it and then delete the new sheet. That can all be written as a macro.
John King <[EMAIL PROTECTED]> wrote:
Harold Fuchs wrote:
> JosephK wrote:
>> Is it possible to append a CSV file to an existing sheet? If
>> so how? At the moment I am having to daily insert a sheet from
>> a CSV file then select all the cells than paste it into the
>> main sheet.
>>
>> The CSV file is created using a Python script I wrote to parse
>> a printable report file (.dfp) and extract the relevant info.
>>
>> Regards, Joseph
>>
> Insert>Sheet From File and then choose CSV format.
>
As far as I can see, this command inserts a sheet either before
or after the current one, whereas I think the original poster
wants to append the data to his current sheet (as in Excel
Data - import external data, which gives a choice of appending
or creating a new sheet). It seems as if calc doesn't give this
option but always creates new sheets.
--
John
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Pinpoint customers who are looking for what you sell.
