xlsread on mac os x!

2012 5 9
1 个回答
回答已采纳
6 次查看（30 天）

0 个投票

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
Friedrich 2012-5-9
can you post your line of code and the error message you get?
babak
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.

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Walter Roberson
Walter Roberson 2012-5-9

0 个投票

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更早的评论

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

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by