xlsread returning NaNs when reading spreadsheet
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hi,
I am using Matlab 2013b and Office 2010. I am reading an excel sheet with the code
[ num, txt, raw ] = xlsread(fullpath, sheets{idx_sheets})
I have looked in both num, txt, and raw but none of those outputs give the complete spreadsheet values. I get a lot of NaN's in parts of the spreadsheet. When I save the spreadsheet to a csv and then save it again as an xls, the code works and I can read all the numbers and strings on the spreadsheet.
Does anyone know of this issue?
Thanks, Horace
0 Kommentare
Antworten (3)
Image Analyst
am 30 Mär. 2015
raw should give the actual data. If not, attach your workbook with the paperclip icon and tell us one particular cell (row and column) in your workbook that has good data in it but that the raw array has NaN for.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!