News:

alphaMELTS 2.3 standalone & for MATLAB/Python is now open source and available on GitHub (https://github.com/magmasource/alphaMELTS).
alphaMELTS 1.9 is available at the legacy download and information site.
For news of all MELTS software see the MELTS Facebook page.

Main Menu

Troubleshooting importing .tbl files into Excel and MATLAB

Started by Paula, March 20, 2020, 12:30:41 PM

Previous topic - Next topic

Paula

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

Paula

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 option to the mouse (right-click) context menu.

Paula