Setting name of variable equal to name of imported file

1 次查看（过去 30 天）

John 2011-12-19

Hi,

I'm importing data into Matlab from excel via the following command:

cycle=xlsread('E:\DC.xlsx','Sheet1');

How can I set the name of the metadata to be the same as the name of the imported excel file.For example:

sch_metadata.name = 'DC';

It will be looping through files in a folder so I wont know the name in advance

Many thanks

Robert Cumming 2011-12-19

if you must do it then use dynamic fieldnames

metadata.(sch_metadata.name) = cycle

Robert Cumming 2011-12-19

same theory. TO get the filename use:

[fullpath, filename, ext] = fileparts ( 'E:\DC.xlsx' );

Then: sch_metadata.net = filename;

John 2011-12-19

Thanks very much

Matt Tearle 2011-12-19

If you're going to be looping on the files, you're probably doing something like

x = cellstr(ls('*.xlsx'));
for k = 1:length(x)
  % do stuff
end

In the "do stuff" bit, you should use fileparts to pull apart each filename string:

[~,fn] = fileparts(x{k});
sch_metadata.net = fn;
save(fn);
% or save([fn,'.mat']) if you want to be explicit

John 2011-12-19

Thanks very much

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

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

Translated by