How to read an excel spreadsheet, fetch a certain cell data
7 次查看(过去 30 天)
显示 更早的评论
- *Hallo all, I think it might be pretty easy. For now i don't get it. How can i read an excel sheet having certain data. I have data with variables and also numerical values.How can i read specific cell i want to read. I am able to read the data of a specific cell by num = xlsread(filename,xlRange). The problem is, i have created my structure and i need to assign the data values from the read excel sheet to my structure. how do i do that ? please help any example would be helpful.!!
thanks.**
0 个评论
回答(1 个)
KALYAN ACHARJYA
2017-8-30
%
filename='excel_sheet.xlsx'; % This file should be inside the working directory/Complete path Name
sheet=1;
cell_location='A2'; % Cell location % For range use 'A2:B6'
data=xlsread(filename,sheet,cell_location);
%
另请参阅
类别
在 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!