Reading excel file in MATLAB (GUI)

2 次查看（过去 30 天）
Samer Husam
Samer Husam 2012-5-29
Hi, I want to read two values in an excel sheet and sum these values by pressing (Push_button) but I am getting an (??? XLSREAD unable to open file Data_sheet.xls.) and stating that the file is not found. my code is :
a=xlsread(‘G:\Master\Program\Calculator\Data_sheet.xls’,'B5′);
b=xlsread(‘G:\Master\Program\Calculator\Data_sheet.xls’,'B6′);
c=a+b;
set(handles.text1,'string',c);
why I am having this error? and how can I come over it ? please help ?

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

采纳的回答

Samer Husam
Samer Husam 2012-5-29
a=xlsread(‘G:\Master\Program\Calculator\Data_sheet.xls’,'Sheet1','B5′);
b=xlsread(‘G:\Master\Program\Calculator\Data_sheet.xls’,'Sheet1','B6′);
c=a+b;
set(handles.text1,'string',c);

更多回答（2 个）

Samer Husam
Samer Husam 2012-5-29
any suggestions please ?
Vishnu Swaroop
Vishnu Swaroop 2012-6-4
put the file in your matlab folder and say : a=xlsread('Data_sheet.xls')
This should work out fine, but using 'B5' like that won't help. Try instead: a=xlsread('Data_sheet.xls','B5:B6')
This should give 'a' as an array with the two elements that you want to add as : c=a(1)+a(2)
Hope this helps.

类别

在 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!

Translated by