xlsread returning NaNs when reading spreadsheet
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (3)
Image Analyst
el 30 de Mzo. de 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 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!