How to read 1st coloumn from excel sheet which contains 60x3 values.
조회 수: 16 (최근 30일)
이전 댓글 표시
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
2015년 3월 28일
편집: per isakson
2015년 3월 28일
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
per isakson
2015년 3월 28일
편집: per isakson
2015년 3월 28일
"in the same manner"   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!