Function with xlsread including the excel file name as input variable

3 次查看（过去 30 天）
Christian F.
Christian F. 2013-3-28
Hi,
I have the following problem: I have multiple excel files named after countries, e.g. US,UK,FRA,JPN,... .
Now I want to write a function, which takes the name of the excel file as input string, e.g. 'JPN' and then loads the corresponding excel file e.g. data = xlsread('JPN',sheet1).
I tried using eval, but could'nt get it to work.
Best and thanks in advance, Chris

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2013-3-28
filename = 'JPN';
data = xlsread(filename, sheet1);

更多回答（1 个）

Christian F.
Christian F. 2013-3-28
Maybe I should ad that I also want the variable, to which the data is stored, to be the named after the respective country, e.g. JPN = xlsread(JPN);

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by