Extracting Names from Excel

2016 7 26
1 个回答
回答已采纳
更新时间：2016 7 26
5 次查看（30 天）

0 个投票

Hello, i have created a list of .txt files in excel (myData.xlsx) that look something like this:
ABC_123.txt
DEF_345.txt
GHI_678.txt
I would like to access this excel sheet and pull out cell A1 and open the file ABC_123.txt. I have tried this using xlsread and winopen but to no avail.
Below is what i have tried:
filename='myData.xlsx';
sheet=1;
xlRange='A1:A1';
subsetA=xlsread(filename,sheet,xlRange)
winopen(subsetA)
Any help is greatly appreciated!

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

 采纳的回答

Miyuru K
Miyuru K 2016-7-26

1 个投票

filename='myData.xlsx';
sheet=1;
xlRange='A1:A1';
% Text fields are stored in cell array txt
[num,txt,raw] =xlsread(filename,sheet,xlRange)
% cell array content indexing to get the string value
winopen(txt{1,1})

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by