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+unsubscr...@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