Extracting Names from Excel

4 次查看（过去 30 天）
John Bowling
John Bowling 2016-7-26
回答： Miyuru K 2016-7-26
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
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 个）

类别

在 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