Solved

Viewing XML as a table on a Mac

Posted on 2016-09-13
3
322 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
[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
  • 2
3 Comments
 
LVL 9

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

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

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.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

751 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