Solved

Viewing XML as a table on a Mac

Posted on 2016-09-13
3
90 Views
Last Modified: 2016-09-16
I am looking fo a way to view XML files in a table the way Excel shows them on WIndows, but am on OSX.  From what I understand Office Does not Support the XML table view on OSX.  Is there a XML viewer that will parse the XML files the way Excel does in Windows?   I can work around this by connecting to a Server that has Excel on it and viewing the files through there, but it would be more convenient to be able to do this from my own machine.   I have not seen much that shows whether this is easy to do or not, and if I have to go and run the files through a converter of some kind Before viewing it doesn't save my any time and I can just go through the virtual desktop I can access.  I guess I am just wondering if that is my best solution or if there is a viewer that is native in OSx.

Thanks
Jason
0
Comment
Question by:JrayPatten
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
Tim Lapin earned 500 total points
ID: 41796143
It seems that there is no simple solution to this one that is native to the mac, as you have pointed out in your question.  The closest I've come is to use an editor like TextWrangler, which allows for colour coding of various items based on types.

The result is not as clean as a table but it can be legible with the right colour choices.  The defaults aren't bad but they can be changed.  There are xml specific colour codes and the rest seem to be under the "HTML" text colour settings in the Preferences.

Xcode is another option but I find that unwieldy and possibly not generic enough for your purposes.  Other apps are either commercial or are overkill for your stated task.

Give the ones I suggested a try.  If they don't work for you, then you have the server based copy of Excel as a great fallback.
1
 

Author Comment

by:JrayPatten
ID: 41796288
Thanks for the reply, and I DO have  textwrangler available already.  Just the various files I am trying to view the table view would make it easy to very quickly scan for the specific types of error I am looking for.
It looks like it will be using the server for viewing.
0
 

Author Closing Comment

by:JrayPatten
ID: 41801641
Thanks for the reply, I kind of figured that was the way it was going to work.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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…

861 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

22 Experts available now in Live!

Get 1:1 Help Now