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

Posted on 2013-05-15
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?
Question by:capturetheflag
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3

Author Comment

ID: 39169272
Additional Footnote:

I do not have an XSD!

LVL 60

Expert Comment

by:Geert Bormans
ID: 39169493
you can use
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

Author Comment

ID: 39216729
No money to buy oxygenxml.

Thanks for the suggestion
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

LVL 60

Accepted Solution

Geert Bormans earned 400 total points
ID: 39216885
inside Oxygen it is Trang (open source) that takes care of the functionality
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

Author Closing Comment

ID: 39220045
thanks for the help
LVL 60

Expert Comment

by:Geert Bormans
ID: 39220281

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

726 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