R2013a Linux Mint + LibreOffice

I am fairly new to matlab and transitioned to linux mint a few days ago. Whenever i use the xlsread() function on a spreadsheet (does not change whether I use .ods .xlsx or other formats) to import data I get NaN entries for some values. Furthermore it seems that Matlab does not import the whole data set. I tested this with a .xlsx file containing 70 values dived ed in two columns. When i defined x using x=xlsread('path','','','basic') Matlab showed only every 5th value, starting with the 5th one. The rest was shown as NaN and the values 1-5 didn't even show up. I did exactly the same 1 week ago on a windows PC and everything went just fine. Additionally Matlab wont allow me to import just using the explorer, always telling me: "index exceeds matrix dimensions"

1 Comment

Are there any special characters in the cells that are read incorrectly?
You can also provide the range of cells you wish to read:
[xlnum,xltxt] = xlsread(fname,'Sheet1','A1:AA131','basic')

Sign in to comment.

Answers (0)

Products

Asked:

f24
on 27 Mar 2017

Commented:

on 30 Mar 2017

Community Treasure Hunt

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

Start Hunting!