XML and Excel

[realmfighter]

Hi,

I have an excel spreadsheet, looking like the following:

img371.imageshack.us/img371/2564/ttexcelfd1.jpg

and I'm looking to do the XML magic to turn it into...

e.g.

<student id="76" last="76" first="76" groups="3E, 3/PE1B, 3/CT.1C, 3/GB, 3/M.1"/>


The thing is I have zilch experience with XML and I am totally lost on how to do this (particularly in making the xml conform exactly to the example). I know how to apply an XML map to the excel file, it just how should I create this map file and what should it be like to end up with the above result?

Any help would be most appreciated!

[Charles]

Your best bet is to save the file as comma separated values (CSV), which you can do in Excel, and then use Perl or PHP or some other scripting language to format the data.

[realmfighter]

Thanks for the quick reply Charles; I'll have a go at that but I'm very inexperienced with scripting so...