Extracting Names from Excel
조회 수: 1 (최근 30일)
이전 댓글 표시
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!
댓글 수: 0
채택된 답변
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!