Does anyone know how to enter list of website resources and output an xml doc for Flash use

I've got to construct a basic xml file listing website assets (pictures and text strings) that a flash photo gallery references.

I'm using a Mac and OpenOffice. I've got Dreamweaver, dashcode, and a couple of open source IDE's. I'm not a programmer, so scripting gets a little difficult.

I'm hand typing the file right now, but the task is very slow beca开发者_如何学JAVAuse of the number and order of the "fields" and values for each record in the xml.

Is it possible to set up a spreadsheet of the data and then parse an xml file from that? I've got to follow this format for each record:

<photo imageurl="url" linklabel="text"linkurl="url" showFlipButton="true"><title>text</title><description>text</description></photo>

Thanks a lot everyone.

---

Using MSExcel I would use the Concatenate() function to manually build out the XML for each row, as a quick and dirty solution. You should be able to do this with OpenOffice as well.