Solved

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

Posted on 2013-05-15
6
402 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
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 demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

708 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now