BHAVISHYA BANSAL
2016-10-05 10:28:03 UTC
Hello,
I also faced the same issue. The following solution worked for me:
Save your excel file as ".xlsx" in place of ".xls". Then try reading it with 'xlsread' (but don't forget to mention .xlsx also as the file format while calling xlsread function).
Hope so it also works for you.
Thanks,
Bhavishya Bansal.
I also faced the same issue. The following solution worked for me:
Save your excel file as ".xlsx" in place of ".xls". Then try reading it with 'xlsread' (but don't forget to mention .xlsx also as the file format while calling xlsread function).
Hope so it also works for you.
Thanks,
Bhavishya Bansal.
hi
when i tried to use 'xlsread' to open an xls file created by excel
Error in ==> D:\MATLABR12\toolbox\matlab\iofun\private\biffparse.dll
Error in ==> D:\MATLABR12\toolbox\matlab\iofun\xlsread.m
On line 89 ==> [n, s] = biffparse(biffvector, names{1});
matlab version: MATLAB Version 6.0.0.88 (R12) on PCWIN
excel version: Microsoft excel 2000 Chinese Edition
windows version: Window98 Chinese Editon (4.10.2222A)
I know i could get excel data by first exporting excel file to txt
format and then loading it in matlab. But it is a little bit
laborious.
Is there any convenient way to read excel data in matlab enviroment?
Or 'xlsread' in newer version of matlab(eg 6.1) can support unicode?
Thanks
Yuan
when i tried to use 'xlsread' to open an xls file created by excel
[a,b]=xlsread('1.xls')
??? XLS File contains unicode text which is not yet supported.Error in ==> D:\MATLABR12\toolbox\matlab\iofun\private\biffparse.dll
Error in ==> D:\MATLABR12\toolbox\matlab\iofun\xlsread.m
On line 89 ==> [n, s] = biffparse(biffvector, names{1});
matlab version: MATLAB Version 6.0.0.88 (R12) on PCWIN
excel version: Microsoft excel 2000 Chinese Edition
windows version: Window98 Chinese Editon (4.10.2222A)
I know i could get excel data by first exporting excel file to txt
format and then loading it in matlab. But it is a little bit
laborious.
Is there any convenient way to read excel data in matlab enviroment?
Or 'xlsread' in newer version of matlab(eg 6.1) can support unicode?
Thanks
Yuan