Effacer les filtres
Effacer les filtres

How to save the read(load) data in spirited files?

1 vue (au cours des 30 derniers jours)
Chuanjung Lin
Chuanjung Lin le 25 Jan 2018
Commenté : Sumeet Gadagkar le 5 Fév 2018
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.
  1 commentaire
Sumeet Gadagkar
Sumeet Gadagkar le 5 Fév 2018
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!

Connectez-vous pour commenter.

Réponses (0)

Catégories

En savoir plus sur 工作区变量和 MAT 文件 dans Help Center et File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!