A tool to convert a table into XML file?

15 Apr 2008 - 9:53pm
6 years ago
5 replies
1707 reads
Oleh Kovalchuke
2006

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.

Thanks, Oleh

Comments

15 Apr 2008 - 10:00pm
Steve Baty
2009

Oleh,

Take a look at XML Spy (http://www.altova.com/features_convert.html) - it
seems to do what you need; and it isn't terribly expensive for the basic
product.

Regards
Steve

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

16 Apr 2008 - 9:16am
Switzky, Andrew
2007

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

16 Apr 2008 - 7:44am
Jerry Sheehan
2008

Hi Oleh,

Better efficiency is achieved through Altova's MapForce product. You
only need to first save your spreadsheet to a csv file which can then
be used in the software to map to a xsd to create an xml.

(
http://www.altova.com/products/mapforce/legacy_text_files_to_xml_mapping.html
)

If you don't have a xsd or dtd, then you can use XMLSpy to generate
or create one.

MapForce includes a ton of features such as code generation, a
command line interface, ActiveX control, API, and many more to make
this process a snap.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Posted from the new ixda.org
http://www.ixda.org/discuss?post=28105

15 Apr 2008 - 10:26pm
jeff
2008

If you know any programming, it wouldn't be too hard to write this
using the XML libraries in Java or .NET (surely there are others as
well). You could export the Excel file as plain text CSV and just
read through it, creating the XML elements.

> Is there a tool to convert tables into XML files?
> Free would be nice.

17 Apr 2008 - 6:17pm
Caitlin Gannon
2008

Babel from MIT might work ... it's an online file converter, and has an application/XML output option.

http://simile.mit.edu/babel/

Good luck!

--Caitlin

____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

Syndicate content Get the feed