xlsread returning NaNs when reading spreadsheet
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(3 个)
Image Analyst
2015-3-30
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 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!