Save in a variable Excel cells Matlab

조회 수: 1 (최근 30일)
Addison Rodriguez Casallas
Addison Rodriguez Casallas 2017년 12월 5일
댓글: Addison Rodriguez Casallas 2017년 12월 5일
would like please can you help me validate the following, I have a database in Excel, this has several columns among which there are numbers, decimals and text, how can I save each excel cell and save them in a variable in Matlab, in order to show them later in a text.
thank you very much for your valuable help,
best regard
Addison

답변 (1개)

ANKUR KUMAR
ANKUR KUMAR 2017년 12월 5일
filename = 'myExample.xlsx';
sheet = 1;
xlRange = 'B2:C3';
subsetA = xlsread(filename,sheet,xlRange)
  댓글 수: 1
Addison Rodriguez Casallas
Addison Rodriguez Casallas 2017년 12월 5일
thanks for your answer, but how I can do for example in the file.xls I have several rows, I want that from matlab when typing an ID this search in the excel file and bring me all the fields in that row. for example I look for the ID 123456 in matlab, if it is in the excel file I need to bring me the whole row that would have the fields name, surname, phone number, age? and that each data of each cell keeps it in a variable. How could I do this ???

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by