xlsread returning NaNs when reading spreadsheet
3 views (last 30 days)
Show older comments
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 Comments
Answers (3)
Image Analyst
on 30 Mar 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 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!