Problems in reading XLSX file

8 次查看（过去 30 天）

pietro 2014-10-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/160787-problems-in-reading-xlsx-file

Hi all,

I have some problems in reading xlsx files. I use the readtable command because I can get a structure where the fields have the same name of the header of the excel file, but I get the same problem with xlsread. Yesterday everything worked fine but not today. When I type:

[~ ~ raw]=xlsread('Filename.xlsx')

matlab halts, niether CTRL+C works, I have to kill the excel process and then it's fine. Here the error I get.

Error using xlsread (line 247)
Error: The remote procedure call failed.
Error in importdata>readFromExcelFile (line 707)
    [n,s,raw] = xlsread(FileName,descr{i});
Error in importdata (line 165)
            out = readFromExcelFile(FileName, descr, out, bFlatten);

I have discovered the problems doesn't appear if I specify the cell range to read, but as I said, yesterday it worked fine without. What may I do to solve the problem?

Thank you