How to import an excel sheet into MATLAB
조회 수: 74 (최근 30일)
이전 댓글 표시
Hi..I have an excel sheet consisting of say, 10 rows and 5 columns. Now, I need to read these values from the excel sheet, perform some mathematical operation on these values and then store the data in a new array. Please help me out with this.
Also, if there are 'n' such worksheets, I need to select few particular worksheets and then perform the operation on only these sheets and the remaining should remain intact.
댓글 수: 0
채택된 답변
Ryan Livingston
2013년 3월 8일
XLSREAD can do it programatically:
and there are some GUI's which let you do it too:
댓글 수: 0
추가 답변 (1개)
Ruben
2013년 3월 8일
편집: Ruben
2013년 3월 8일
make sure the excel sheet you want to import from is in your current directory, then double click it (in the current folder section of your MATLAB window). You will receive options to import it.
Another way (which I prefer) is just copy paste. Right click in your workspace and select 'new'. You can then edit this variable in the variable editor and paste the required fields from your excel file.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!