?
Solved

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

Posted on 2013-05-15
6
Medium Priority
?
419 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
[X]
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
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 60

Accepted Solution

by:
Geert Bormans earned 1600 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

765 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