How to read an excel spreadsheet, fetch a certain cell data
7 views (last 30 days)
Show older comments
- *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 Comments
Answers (1)
KALYAN ACHARJYA
on 30 Aug 2017
%
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);
%
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!