How to open cell array in excel?
조회 수: 3 (최근 30일)
이전 댓글 표시
I have a cell array of size {C}=100x1 and inside each cell there is a column vector of varying length. For eg. C{1,1}=50x1,C{2,1}=100x1 and so on. I want to read this cell arrray in excel file.
댓글 수: 2
답변 (2개)
madhan ravi
2018년 11월 29일
편집: madhan ravi
2018년 11월 29일
I think you mean from excel file - then use readtable() to read the file
celldisp() to view the contents of each cell
댓글 수: 3
madhan ravi
2018년 11월 29일
celldisp() is used to display the contents in a cell array btw what are you trying to achieve?
Walter Roberson
2018년 11월 29일
Excel is not able to represent anything like that.
The most direct match might be if you made every cell into a different Excel "sheet".
The second best match would be if you were to make each column of a normal sheet a different size. If you were to read a specific range such as B:B then you would get back just that one column. If you did not read a particular range, then the numeric array you would get back would have the same number of rows for all columns, but the unused entries would show up as nan.
댓글 수: 1
Walter Roberson
2018년 11월 29일
To read a particular sheet from an xls or xlsm file, you can use xlsread() passing in the sheet information after the file name, or you can use readtable() with the 'sheet' option.
To write to a particular sheet of an xls or xlsm file, you can use xlswrite() passing in the sheet information as the third parameter (after the file name and data to be written), or you can use writetable() with the 'sheet' option.
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!