[IxDA Discuss] A tool to convert a table into XML file?

[Switzky, Andrew]

You can use Excel to generate an xml file. I have done this using excel
2003.

First, you need to create an XML file that defines the schema.

Second, within Excel go to Data > XML > XML Source. On the XML source
pane, select XML Maps and click Add. Then you can import your xml
schema.

Third, you can map each column in the worksheet to an element in the XML
source. You can drag the xml element to the column to which you want it
to map.

Finally, save as XML Data (*.xml)

Andy Switzky
Senior Information Architect
Austin Energy - Web/Portal Services
www.austinenergy.com
 
w: 512.322.6318
f: 512.322.6025

On 16/04/2008, Oleh Kovalchuke <tangospring at gmail.com> wrote:
>
> I needed to convert a fairly large Excel table into XML file to build
a
> sortable Spry table in Dreaweaver, and I thought there could be a
> converter
> of sorts in either of the programs. No such luck.
>
> After poking around and doing the usual Google research I couldn't
find
> any
> free tools, so I have resigned to doing it manually (a lot of "find
and
> replace", and "save as"). The good news: the table works, the bad
news:
> the
> process was tedious, exactly the kind, we have "Intel Inside" for.
>
> Is there a tool to convert tables into XML files?
> Free would be nice.
>


----------------------------------------------
Steve 'Doc' Baty B.Sc (Maths), M.EC, MBA
Principal Consultant
Meld Consulting
M: +61 417 061 292
E: stevebaty at meld.com.au

UX Statistics: http://uxstats.blogspot.com

Member, UPA - www.upassoc.org
Member, IA Institute - www.iainstitute.org
Member, IxDA - www.ixda.org
Contributor - UXMatters - www.uxmatters.com
________________________________________________________________
Welcome to the Interaction Design Association (IxDA)!
To post to this list ....... discuss at ixda.org
Unsubscribe ................ http://www.ixda.org/unsubscribe
List Guidelines ............ http://www.ixda.org/guidelines
List Help .................. http://www.ixda.org/help