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

On Sun, 2013-11-03 at 21:16 +0100, Regina Henschel wrote:
> Hi Mario,
>
> Mario Splivalo schrieb:
> > Hi, all.
> >
> > Once in the past I stumbled upon a blog where owner explained how one
> > can create a Calc document from the data that's in the XML file. I'm not
> > sure if XML contained only the data which then populated the Calc
> > template, or the whole Calc data was in that XML (not even sure if the
> > source was XML or was it some other human-readable file), but I haven't
> > been able to locate that blog ever since.
> >
> > I'd appreciate any info or pointers on how above mentioned can be achieved.
> >
> > I need to create several daily reports on some processes I'm overseeing,
> > and entering all that data into the Calc spreadsheet is cumbersome - the
> > report resembles of a tax-return/invoice sheet, where various fields
> > need to be populated - and I'm looking for a way to automate this.
>
> In which form do you get the data? Perhaps there is nothing like XML 
> needed, but you can import the data directly.
>
> Do you want to write macros for Calc or do you want to use another 
> application that manipulates the .ods file source?
>
> >     Mario
> >
> > P.S. I apologize if I posted this to the wrong mailinglist, please
> > redirect me if necessary.
>
> "users" is OK.
>
> Kind regards
> Regina

I have done this for some special logging I do, by simplying creating my
own template, saving the data in a csv (comma separated value format)
and then loading the data into the template.  I do this manually, but a
macro could be created to do it as well.

Regards,
Les H


-- 
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