Re: [libreoffice-users] Creating LibreOffice Calc document from XML (or some other file?)

Hi Mario,

Sorry, by your description I understood you to mean you *did* want to
poke into the ods file directly.

I would consider scripting something to create the files
automatically the best option, but then again, I'm a programmer, so it
would be my first thought :)

I see a few possible menu items in Calc that might provide what you
want, unfortunately I don't know them, so someone else will have to
comment on their suitability. I'll just list them, and you can research
further.

View | Data Sources
Insert | Link To External Data
Data | XML Source

Regards

Paul


On Sun, 03 Nov 2013 21:35:14 +0100
Mario Splivalo <mario@splivalo.hr> wrote:

> On 11/03/2013 09:13 PM, Paul wrote:
> > Hi Mario,
> >
> > I'm sure others on this list can advise you more completely, but
> > I'll have a quick stab at it. As I understand it, the LO document
> > format is a zipped file consisting of XML files for the contents.
> > One way of doing what you need should be to create a file with the
> > layout you need and some sample data, then save that. Then rename
> > the file extension to zip if need be, and open it in an archive
> > manager. Extract the contents to a working directory and examine
> > the files. You should find one with the sample data in XML format.
> > You should be able to use that as a template, and create a script
> > or program to replace the sample data with live data and re-zip the
> > files into a working Calc file.
> >
> > Hope this is what you were looking for.
>
> I was hoping for a method so I don't need to poke with .ods files
> directly :) The XML source can, I guess, be any source...
>
>
>       Mario


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted