MATLAB app designer run issue

1 view (last 30 days)
Prajwal Venkatesh
Prajwal Venkatesh on 19 Feb 2020
Commented: Jyotsna Talluri on 26 Feb 2020
I get this issue every other random time
Sometimes it works sometimes it dosent
Error using xlsread (line 257)
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Excel cannot open the file 'Bunks11.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
Help File: xlmain11.chm
Help Context ID: 0
Error in manpower2 (line 7)
parfor k=1:numel(sheet_name)
What is the solution?
  2 Comments
Prajwal Venkatesh
Prajwal Venkatesh on 26 Feb 2020
But can i run it any faster?

Sign in to comment.

Answers (1)

Jyotsna Talluri
Jyotsna Talluri on 25 Feb 2020
The error may be due to the Excel COM Automation server. Kill all running Excel processes from Windows Task Manager if any and try restarting the MATLAB and run the script again. If the issue still persists, then try using xlsread in ‘basic’ mode.
Refer to the below link to know more about ‘basic’ mode
As xlsread is not recommended to use in the latest versions of matlab, I would suggest you to use readtable instead.
  2 Comments
Jyotsna Talluri
Jyotsna Talluri on 26 Feb 2020
Reading files in .csv format takes less time compared to reading files in .xlsx format .Even using the readtable in 'basic' mode reduces the time to some extent

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by