Re: [sheflug] Slightly Off-Topic, Openoffice Help

["Alec Melling" <alec [at] xxxxxxxxxxxxxx>]

On Mon, 14 Aug 2006 15:26:05 +0100, Ashe <ashe [at] techromantic.co.uk> wrote:

> Can anyone point me towards a decent reference or bit of info that can
> tell me how I'd do the following?
>
> I have a bunch of calc spreadsheets, each of which has a sheet which is
> an attendance roster. I need some method of iterating through each file,
>   extracting the data from that one sheet in each file, and writing out
> another spreadsheet with, for example: Name, Member Number, Count of
> Attendances.
>
> Am I better copying all those sheets into another file and working on it
> from there? Is this something I can do with the built-in functions, or
> am I going to have to start faffing round with basic and stuff?
>
> AH

Are you looking at linking data in a series of spreadsheets to a master  
document? If so there is a howto on the OO website which should walk you  
through it. Once you have set it up you should be able to write a macro to  
automate the process. As long as you have OO java enabled.

If this its a reasonably complex thing you want to do post it on the OO  
forum. There are guys on that forum who live for a complex task to prove  
how good OO is. Anything Office can do, we can do better...

-- 
Alec Melling

0114 2343612

___________________________________________________________________

Sheffield Linux User's Group -
http://www.sheflug.co.uk/mailfaq.html

  GNU the choice of a complete generation.