Solved

XML files which I need the XSD and XSL for EXCEL maps

Posted on 2013-05-15
6
406 Views
Last Modified: 2013-06-04
I have some XML files which I need the XSD and XSL for EXCEL maps. I usually use Access to create them from the XML.

Any ideas on a quicker method?
0
Comment
Question by:capturetheflag
  • 3
  • 3
6 Comments
 
LVL 1

Author Comment

by:capturetheflag
ID: 39169272
Additional Footnote:

I do not have an XSD!

capturetheflag
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 39169493
you can use
www.oxygenxml.com
for generating a schema from a collection of XML files

XSLT usually is custom development
(I assume you need to flatten the XML structure a bit for getting an excel table format)

If you are working on the XSLT anyway, and you don't need a databinding, but just the XML import in Excel, you could use the XSLT to transform into a HTML table and import that... I very often take that approach
0
 
LVL 1

Author Comment

by:capturetheflag
ID: 39216729
No money to buy oxygenxml.

Thanks for the suggestion
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 60

Accepted Solution

by:
Geert Bormans earned 400 total points
ID: 39216885
inside Oxygen it is Trang (open source) that takes care of the functionality
http://www.thaiopensource.com/relaxng/trang.html
Oxygen only serves as the graphical configuration for schema generation

well, you could download an evaluation for a month. That is free
This way you could check wether the approach helps you in a friendly environment.
If you like the Oxygen approach, forget about Oxygen but remeber the configuration settings
and use Trang for free, directly from the command line
0
 
LVL 1

Author Closing Comment

by:capturetheflag
ID: 39220045
thanks for the help
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 39220281
welcome
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question