Saving Imported Data automatically
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
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
Ali Kareem
on 19 Nov 2015
Stephen23
on 19 Nov 2015
Make that line a comment, it is not code that can run:
% oh oh, how did this happen?
Ali Kareem
on 20 Nov 2015
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.
Ali Kareem
on 20 Nov 2015
Categories
Find more on Whos 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!