Warning Message "unable to write to Excel format"

조회 수: 67 (최근 30일)
Rita Sciuto
Rita Sciuto 2019년 7월 3일
댓글: Walter Roberson 2020년 2월 8일
I'm solving a problem with variational inequality. I have a code but after 6 iteractions Matlab blocks and gives me this Warning:
Unable to write to Excel format, attempting to write file to csv format. To write to an
Excel file, convert your data to a table and use writetable.
What's the meaning?
  댓글 수: 2
KALYAN ACHARJYA
KALYAN ACHARJYA 2019년 7월 3일
It would be helpful to answer, if you share the code or representational code?
Rita Sciuto
Rita Sciuto 2019년 7월 3일
I sent you a message

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

답변 (1개)

Jiajia
Jiajia 2020년 2월 8일
I have encountered a similar problem. How can I sove it?
  댓글 수: 1
Walter Roberson
Walter Roberson 2020년 2월 8일
If you have a new enough version of MATLAB, change all of your calls to xlswrite() to be calls to writetable() or writematrix() or writecell(), passing in the 'UseExcel', false option. Also, change any xlsread() to readtable() or readmatrix() or readcell() with 'UseExcel', false . This will prevent Excel from being invoked to read of write the excel file.
Avoiding Excel can be important because historically the connection with Excel can sometimes get stuck with a file open as far as Excel is concerned, and then the file is busy when you go to write it. Sometimes this can occur if you do two xlswrite() to the same file in quick succession, as Excel does not necessarily finish flushing the file and closing it before it returns from the ActiveX connection that xlsread() and xlswrite() use on MS Windows machines with Excel installed.

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

카테고리

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