Reading excel file in MATLAB (GUI)

2012 5 29
3 个回答
回答已采纳
4 次查看（30 天）

0 个投票

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

0 个投票

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 个）

Vishnu Swaroop
Vishnu Swaroop 2012-6-4

0 个投票

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.

类别

在 帮助中心 和 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