Excel-like software for XML data?

Is there any Excel-like software for XML data?

Something not restricted to spreadsheet format, but allowing:

data with hierarchy
more strict typing
tagging
multiple views to the data, unlike Excel's plain spreadsheets

For example, in a kind of a music library, if we have artists, albums and tracks, and each of them has a few attributes, and some attributes are numeric, some are sets of tags (where order is not important), some are lists (where order is important).
We'd need to edit, browse, filter this data dynamically, do basic calculations, and keep relations between entities.

Ognjen

Posted 2012-03-02T14:41:34.390

Reputation: 509

Spreadsheet programs and the functions they offer are bound to the paradigm of information ordered in a 2-dimensional grid. XML is completely different – information is represented as a tree. Can you give an example of what data you have and what you want to do with it? – slhck – 2012-03-02T15:05:51.123

For example, in a kind of a music library, if we have artists, albums and tracks, and each of them has a few attributes, and some attributes are numeric, some are sets of tags (where order is not important), some are lists (where order is important). And we need to edit, browse, filter this data dynamically, do basic calculations, and to keep relations between entities. – Ognjen – 2012-03-02T15:38:25.073

Answers

I have been looking for something like this for a long time, with the advent of XML and XHTML, I find that it would be useful to populate XML type data from a spreadsheet.

The following systems are close to the functionality that you describe, however its not 100 percent.

Altova XML Spy grid view:

enter image description here

One with good potential is the XMLMind software. The ellipsis indicate that there is a complex one to many relation within the cell, clicking on it reveals the detail.

enter image description here

Hightower

Posted 2012-03-02T14:41:34.390

Reputation: 79

As the comment by @slchk states, there is a difference in the foundations of a spreadsheet's use and XML which is tree based. The spreadsheet is 2D and XML is better for a directory structure of music like you suggest, I have briefly been introduced to oxygenxml link which has many nice views. It has a nice interface for editing data manually, but I don't know how well it interfaces with maybe your own scripts etc. But I guess you could work with the xml it exports.

Vass

Posted 2012-03-02T14:41:34.390

Reputation: 1 389