Borrar filtros
Borrar filtros

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

7 visualizaciones (últimos 30 días)
anush
anush el 30 de Ag. de 2017
Comentada: anush el 30 de Ag. de 2017
  • *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.**

Respuestas (1)

KALYAN ACHARJYA
KALYAN ACHARJYA el 30 de Ag. de 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);
%
  1 comentario
anush
anush el 30 de Ag. de 2017
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.

Iniciar sesión para comentar.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by