Reading a table in excel
조회 수: 1 (최근 30일)
이전 댓글 표시
I am having some trouble with reading a table in excel and then extracting specific rows.
I first use:
filenameEGI='Copy of EGI Yield Data July 2020 7_30_20.xlsx'
fileread=readtable(filenameEGI)
columnData=fileread(2056:2098,:)
In effort to read rows 2056 to 2098. However in certain columns NaN is bein displayed and I would like whatever was in that excel cell to display instead.
Where the NaN displayed, in the excel cell it displayed words and file folder links.
Any suggestions or application of corrections?
댓글 수: 4
Walter Roberson
2020년 8월 12일
table does support characters, but csvread() does not.
Columns that contain a mix of numbers and text will generally be detected as text, but that depends upon the release and the fraction of text. Older releases that did not automatically use detectImportOptions were more likely to guess that a file with leading numbers would never have text; detectImportOptions goes a better job of figuring out columns.
Walter Roberson
2020년 8월 12일
You could consider using readcell() : the entries that can be converted to numeric will be converted, but will be left in individual cells.
You can then use cellfun(@isnumeric) or similar to locate non-numeric entries.
답변 (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!