How to read an excel spreadsheet, fetch a certain cell data

Question

anush 2017-8-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354555-how-to-read-an-excel-spreadsheet-fetch-a-certain-cell-data

评论： anush 2017-8-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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KALYAN ACHARJYA 2017-8-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354555-how-to-read-an-excel-spreadsheet-fetch-a-certain-cell-data#answer_279680

在 MATLAB Online 中打开

%
  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);
%

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

anush 2017-8-30

Thank you for your solution Kalyan. Reading an excel data from a cell_location i was able to do. I am stuck in how to write that "read excel data" into my structure which i have defined.

请先登录，再进行评论。