How to read 1st coloumn from excel sheet which contains 60x3 values.

10 次查看（过去 30 天）
krishnasri
krishnasri 2015-3-28
编辑： per isakson 2015-3-28
I have an excel sheet which contains 60x3 values I want to read the entire first column and display it.. can somebody help me with the code

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

回答（1 个）

per isakson
per isakson 2015-3-28
编辑：per isakson 2015-3-28
The documentation on xlsread, Read Microsoft Excel spreadsheet file says
Read the second column from the Excel file in the first example.
filename = 'myExample.xlsx';
columnB = xlsread(filename,'B:B')
Thus, why not first try
columnA = xlsread(filespec,'A:A')
and next
columnA = xlsread(filespec,sheet_name,'A:A')
Is Excel installed on your system?
  2 个评论
krishnasri
krishnasri 2015-3-28
编辑：per isakson 2015-3-28
yes it is installed. when i tried reading in the same manner, it was displaying an error for the code:
Data = xlsread('A_ed.xls');
for i=1:60
col_l=xlsread(Data,'A:A');
for j=1:59
col_m=xlsread(Data,'B:B');
for k=2:60
col_n=xlsread(Data,'C:C');
d(i)=sqrt((l(k)-l(j))^2+(m(k)-m(j))^2+(n(k)-n(j)^2))
e=norm(d(i));
end
end
end
range1=strcat('A',num2str(i));
range2=strcat('C',num2str(i));
xlswrite('A_norm',d(i),'sheet1',range1)
error msg displayed is ??? Error using ==> xlsread at 122
Filename must be a string.
Error in ==> distance_calc at 7
col_l=xlsread(Data,'A:A');
per isakson
per isakson 2015-3-28
编辑：per isakson 2015-3-28
"in the same manner" &nbsp No, you did not!
Concentrate on the reading problem first. Don't involve calculations and writing. It's just confusing.
Given
  • The name of the file is 'A_ed.xls'.
  • The workbook has one sheet or the data is in the first sheet
Am I correct? If so try
data = xlsread( 'A_ed.xls', 'A:A' );
and inspect the content of the variable data
plot( data )

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by