How to save the read(load) data in spirited files?
1 次查看(过去 30 天)
显示 更早的评论
Good day everyone,
I try to read(load) multiple files into matlab, and the code as following:
clear all;
[FileName, PathName] = uigetfile({'*.xlsm'},'Pick a file','MultiSelect', 'on');
str = [FileName PathName];
FileName = fullfile(PathName,FileName);
for i=1:length(FileName)
[~, ~, raw] = xlsread(FileName{i},'0');
raw = raw(262:end,[2,7]);
Name{i} = reshape([raw{:}],size(raw));
clearvars raw;
end
I named the new file name is "Na
me", and in my workspace it shows the result as the attached figure. Who can help me to correct the code? thank you.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/169426/image.png)
1 个评论
Sumeet Gadagkar
2018-2-5
Hey, can you attach some example files which reflect the structure of the data you are working with? Also, can you be more specific on what format the output needs to be in?
Thanks!
回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!