xlsread on mac os x!

Question

babak 2012-5-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/37872-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?

2 个评论
显示无隐藏无

Friedrich 2012-5-9

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

babak 2012-5-10

>> [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 2012-5-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/37872-xlsread-on-mac-os-x#answer_47261

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.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Friedrich 2012-5-10

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 2012-5-10

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.

请先登录，再进行评论。