I have this very basic problem while importing a xlsx file and not able to figure out the reason. I import the file using the following command and end up getting a value in (1,1) and the rest as NaN.
data=('coordinates.xlsx'); coord=xlsread(data);
Can someone point out whats the problem here. Thank you

 채택된 답변

Image Analyst
Image Analyst 2018년 11월 11일

0 개 추천

What made this file? If you open it in Excel, you can see that the cells seem to be randomly formatted as either cell or numbers. Make that program save them all as numbers, not text, and you will be okay.

추가 답변 (0개)

카테고리

질문:

2018년 11월 11일

답변:

2018년 11월 11일

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by