matlab excel, import data excel is fail

i import my data into matlab but fail. Matlab noticed that: "coul not open the spreadsheet. matlab reported the following error: Unreadable excel file: no public fielddisplay alert exists for class COM.excel_application

[Geoff Hayes]

It would be helpful to include the code that you were using to open the Excel file. That may point to why the import failed. If I try [NUM,TXT,RAW]=xlsread('data.xlsx');, then the data is read in successfully.

[Titus Edelhofer]

Just to be sure: when you double click on the file, you can open it in Excel?

[dpb]

Is the file from the Excel version installed on the machine in question? Wondering about version issues.

[sara]

Try to "run MATLAB as administrator". This might solve the problem. Probably MATLAB does not have access to the files...

Answer 1

[Image Analyst]

You probably have some code like this from my demo that I have posted many times:

% If your user has your Excel file already open,
% this code saves & closes the file, then closes excel:
Excel = actxGetRunningServer('Excel.Application');
Excel.DisplayAlerts = false; % Avoid excel warning popups
Excel.WorkBooks.Item('Filename.xls').Save;
Excel.WorkBooks.Item('Filename.xls').Close;
Excel.Quit;

I think the DisplayAlerts property was only introduced recently (Office 2007 or 2010 - I don't remember). You may have a version of Excel prior to when that property was introduced. Just delete that line from your code.

[TRAN]

Thank for your help. Because i have just studied matlab to apply in finance. So i can understand your help clearly. Could you teach me the step to repair that error. May i contact with you by email (my email is [e-mail]) Thank you so much.

[Image Analyst]

1. Type ctrl-f.
2. Paste in "Excel.DisplayAlerts" and
3. click Find Next.
4. Place the cursor to the left margin until the arrow points to the right.
5. Click to highlight the entire line.
6. Type the delete key to delete that line..
7. Type F5 to run your code and test it.

[sara]

Try to "run MATLAB as administrator". This might solve the problem. Probably MATLAB does not have access to the files...

Answer 2

[sara]

Try to "run MATLAB as administrator". This might solve the problem. Probably MATLAB does not have access to the files...