I found a way to do it completely in batch mode, it's a tiny bit
involved, but can email the list if details are needed. Essentially
it's a shell script that calls something like:
oowriter -invisible -headless "macro:///Standard.Module1.CSV2XLS($dir)" $display
where $display is either blank, or via an Xvfb driver running on e.g. :25
You then also need a csv2xls.bas,which i gleaned and edited from what i found
on
http://www.oooforum.org/forum/viewtopic.phtml?t=15402
i needed something in batch since i had to make 25 or so of them, and do it
many times as piece of some workflow. I was impressed with the embedded
language OO has.
- peter
On [Fri Apr 11 05:58], Nikolas Coukouma wrote:
> This came up (re: Powerpoint to HTML) the other day, and I thought I'd
> share my current solution: unoconv.
>
> unoconv leverages the OpenOffice bindings to convert between any format
> the OpenOffice can read or write. It's not completely automatic, since
> you need to tell it what sort of file it is (e.g. presentation), if it
> isn't a document , and what output format you want (pdf is the default).
>
> It isn't all that brilliant...
> unoconv -d presentation -f html foo.ppt
> will produce foo.html ... and a bunch of other html files, along with a
> pile of jpgs. The jpgs are renderings of the slides, and there's a
> parallel run that's just text. The pdf output is much better, IMO.
>
> Also, it require OpenOffice to be running; it will start it
> automatically, and it will remain hidden, but there's no magic to avoid
> that requirement.
>
> The nice thing is that unoconv is, at heart, a very simple script that
> makes a couple calls using the uno python library. Look for "Load
> inputfile" in the code, and you'll see exactly how it works. Writing
> your own script is pretty easy; you just need to know a bit of Python
> and poke through some of the OpenOffice documentation to figure out how
> to do things.
>
> n.b. You can write scripts from within OpenOffice ... in Visual Basic.
>
> Cheers,
> -Nikolas
>