MATLAB: Load data from a table from another file

filetable

Hi everybody,

I am trying to load the data from a table which is located to another file than the location of the script where I want to load it. Is it possible? Thank you in advance for your time.

Best Answer

Sure, just specify the location before the filename, e.g.:

readtable('H:\folder\Table.xlsx')

you can also add the folder to the MATLAB searchpath:

addpath('H:\folder\')
readtable('Table.xlsx')

Related Solutions

MATLAB: Creating a function that reads into the directory

you also need to use dir() to get actual file names. Try this code

% FilePrefix ='DynamicData';
FilePrefix ='test';
DirectoryName = pwd;
filetype='.xlsx';
FileList = fullfile(DirectoryName,[FilePrefix,'*',filetype]); % fullfile is better to construct file paths
FileList = dir(FileList);
TableFiles = cell2table({FileList.name}.', 'VariableNames', {'Filenames'});

MATLAB: Load

Hi Tor,

I don't 100% understand the question: .txt is just as .dat or similar an "indicator" that it's a text file (ascii, not yet nothing to do with MATLAB). The load (as you experienced with testfile.vg) is capable of reading "plain" ascii text files. If the text file contains more than just numbers (like header, dates, etc.), then the other functions for reading ascii files come into play (doc iofun gives an overview).

Titus

Best Answer

Related Solutions

MATLAB: Creating a function that reads into the directory

MATLAB: Load

Related Question