Saving Imported Data automatically
5 views (last 30 days)
Show older comments
Hi,
I am using below code to import data from .dat and .xlsx files. How I can save the imported data in two matrices. I mean .dat imported data save to matrix A and .xlsx imported data save to B matrix
[filename, pathname, filterindex] = uigetfile( ...
{ '*.mat','MAT-files (*.mat)'; ...
'*.slx;*.mdl','Models (*.slx, *.mdl)'; ...
'*.*', 'All Files (*.*)'}, ...
'Pick a file', ...
'MultiSelect', 'on');
Thanks
0 Comments
Answers (1)
Walter Roberson
on 19 Nov 2015
Because you have MultiSelect on, the returned filename will be a cell array of strings. You can loop over those taking one at a time and dealing with it:
for K = 1 : length(filename)
thisfilename = filename{K};
[~, ~, this_ext] = fileparts(thisfilename);
if strcmpi(this_ext, '.mat')
it is a .mat file. Process it
elseif strcmpi(this_ext, '.xlsx')
it is a .xlsx file, process it
else
oh oh, how did this happen? What to do now?
end
end
5 Comments
Walter Roberson
on 20 Nov 2015
The lines "it is a .mat file. Process it", "it is a .xlsx file, process it" and "oh oh, how did this happen? What to do now?" are intended to be places that you replace with code specific to what you want to do with your files.
See Also
Categories
Find more on Workspace Variables and MAT-Files in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!