MELTS Software Users

MELTS for Excel, rhyolite-MELTS (GUI) and alphaMELTS => Operating system specific => MacOS => Topic started by: Paula on March 20, 2020, 12:30:41 PM

Title: Troubleshooting importing .tbl files into Excel and MATLAB
Post by: Paula on March 20, 2020, 12:30:41 PM
On newer versions of MacOS / Excel you might find that .tbl files are greyed out when you try to import them in Excel. One way to fix this is to rename the files to .txt or .csv.  A quicker way is to open Terminal, navigate to the folder where melts.out and the .tbl files are and type:
Quote
setfile -t "TEXT" *.tbl
Unfortunately, this hack doesn't seem to work for MATLAB's Import Data tool. For that you may need to rename the files.

Paula
Title: Re: Troubleshooting importing .tbl files into Excel and MATLAB
Post by: Paula on May 31, 2020, 04:48:06 PM
If you have followed this tip and are finding that the .tbl files are greyed out again, then try this:
Quote
setfile -t "" *.tbl
No idea why that works, but it seems to...

Also, if you find yourself doing this often then you might want to follow this tip to add an open selected Finder folder in a new Terminal window (https://osxdaily.com/2011/12/07/open-a-selected-finder-folder-in-a-new-terminal-window/) option to the mouse (right-click) context menu.

Paula