필터 지우기
필터 지우기

xlswrite error - worksheet could not be activated

조회 수: 55 (최근 30일)
vasja sivec
vasja sivec 2016년 3월 25일
답변: giovanacgois 2018년 5월 17일
Dear Matlab users,
Last week my Matlab started to return an error when trying to export data into excell. For example:
------------- command and error message:
>> xlswrite('myfile',data)
Error using xlswrite (line 219)
Excel Worksheet could not be activated.
------------- error object:
The exception object (from line 219) reads:
-
identifier : 'MATLAB:xlsread:WorksheetNotActivated'
message: 'Excel Worksheet could not be activated.'
cause: 0x0 cell (authors tesxt: an empty cell)
--------------
I can export to other types of files (csv, txt,...)
I am having a hard time understanding what the problem is. I am using my office computer. It might be related to our security policy. Our IT department could not help me.
Anyone had any similar experience and found a solution?
Thank you for your help and kind regards,
Vasja
  댓글 수: 4
K E
K E 2016년 7월 8일
편집: K E 2016년 9월 29일
Presently getting this error on one machine but not another for the same Excel file! And when I quit the Matlab with the error and restart it, I no longer get the error.
Here is the output Walter requested on my particular file, though I am not the original question author:
[status,sheets] = xlsfinfo(filename)
status =
Microsoft Excel Spreadsheet
sheets =
'SheetName1' 'SheetName2'
And here is how I am calling the command when the error is returned,
CsvFile = 'L:\Directory1\Spreadsheet1.xlsx';
[junk,fieldNamesA1,junk2] = xlsread(CsvFile,'SheetName2');
Any help greatly appreciated, since this is preventing running a necessary daily report.
Shashwat Jain
Shashwat Jain 2017년 7월 1일
try to use "xls" format instead of "xlsx". For example.... "filename.xls" worked for my case but "filename.xlsx" didnt work.

댓글을 달려면 로그인하십시오.

답변 (4개)

giovanacgois
giovanacgois 2018년 5월 17일
I tried to re-run Matlab with Admin privileges, it worked for me.

Toritris
Toritris 2017년 1월 10일
Same problem, but over a loop in which the Excel sheet was repeatedly called, it worked the first time, then broke! Opened Excel and there was the 'allow other programs to ...' button, so I clicked it, but it still didn't work. Finally, closed and opened Matlab and it was ok.

Faiz Gouri
Faiz Gouri 2017년 7월 25일
I faced the similar issue with MATLAB R2017a, restarting MATLAB and closing all xls files fixed the problem for me

vasja sivec
vasja sivec 2017년 8월 22일
Just an update...
In my case the culprit was my coding.
I had set up a loop that opened an i) excel file, ii) updated the excel file and iii) closed it. The problem (at least it seems so...) was that somehow the "updating command" (ii) executed before the "close file command" (iii) has properly finished all its tasks.
SOLUTION in my case: I paused the execution temporarily in order to give the "close file command" enough time to finish. I added the following line after the "close file command": . pause(0.5)
Speed was of no essence for my task.
Hope it helps, Vasja

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by