Page 1 of 1

Need to import data from web in xml format?

Posted: Mon Mar 03, 2008 11:18 pm
by Gabe
Hi All -

I use a script feed in XML that is provided to me from service provider, which in the past I have use in excel template. I used the command in excel under the "data" insert from web - inport into excel and reformat for my effort. Rearrange colums and rows....

I'd like to use OpenOffice to try and to the same thing...any ideas/help? I can send sample if that would help.

Many Thnaks-

Gabe

http://statfeed.statfox.com/webservices ... =2/29/2008 this is the linkI would like to import and maintain headings etc.

Re: Need to import data from web in xml format?

Posted: Mon Mar 03, 2008 11:33 pm
by hol.sten
Gabe wrote:any ideas
You can try to create your own XSLT import filter for OOo. Read more on this topic for example here:
- [solved] Calc is crashing while loading XML-file: http://www.oooforum.org/forum/viewtopic.phtml?t=51387
- German: XML Datei importieren die Integerwerte enthält: http://de.openoffice.info/viewtopic.php ... hlight=xsl
- Again only german: Problem mit der Zahlenformatieren nach XML Import: http://de.openoffice.info/viewtopic.php ... slt#p68337