News:

alphaMELTS 1.9 is available at the download and information site.
alphaMELTS 2 standalone & for MATLAB/Python are available on request
(see the Version 2 tab on the download site for more details).
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
Print
Go Down Pages1
User actions

Paula

March 20, 2020, 12:30:41 PM Last Edit: May 12, 2020, 09:42:02 AM by 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

#1
May 31, 2020, 04:48:06 PM Last Edit: October 27, 2020, 09:38:28 AM by 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
Print
Go Up Pages1
User actions