xlsread on mac os x!

i've been used xlsread function on windows with out any problem, but on mac os x, it doesnt work, there is always an error in line 129, file adress in mac os is different from windows, on mac adress is indicated by / but on windows by \ . which of them should i use on mac? i tried both of them, it didnt work, what shoul i do?

[Friedrich]

can you post your line of code and the error message you get?

[babak]

>> [a,pr,b]=xlsread('Users/babakloghmani/Desktop/2','2.xls','a1:a3868')

Error using xlsread (line 129)

XLSREAD unable to open file 'Users/babakloghmani/Desktop/2'.

File 'Users/babakloghmani/Desktop/2' not found.

Answer 1

[Walter Roberson]

The '/' is a valid path separator on both OS-X and MS Windows.

xlsread() on OS-X (and Linux) before R2012a is restricted to "basic mode" and cannot handle .xlsx files or extended .xls files.

[babak]

my matlab is R2012a, but it still doesnt work, i posted my code and error message above, chan you help me on this issue?

[Friedrich]

You use xlsread wrong. The fist input is the path to the xls file:

xlsread('Users/babakloghmani/Desktop/2.xls','a1:a3868') or if the "2" is a folder on your desktop

xlsread('Users/babakloghmani/Desktop/2/2.xls','a1:a3868')

[Walter Roberson]

xlsread('/Users/babakloghmani/Desktop/2.xls','a1:a3868')

Notice the leading "/". Without that, operating systems will look relative to the current directory. The leading "/" tells the OS that the path is absolute.