フィルターのクリア

Info

この質問は閉じられています。 編集または回答するには再度開いてください。

How to rectify errors while using 'xlswrite' function?

1 回表示 (過去 30 日間)
MatlabUser
MatlabUser 2016 年 9 月 3 日
閉鎖済み: MATLAB Answer Bot 2021 年 8 月 20 日
Hello everyone,
I am using 'xlswrite' function for writing data to an excel-sheet. My code is something like this -
values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9};
headers = {'First', 'Second', 'Third'};
xlswrite('myExample.xls', [headers; values]);
I am getting following error message:
"Error using xlswrite (line 220)
Invoke Error, Dispatch Exception:
Source: Microsoft Office Excel
Description: 'C:\Users\Admin\Documents\MATLAB\myExample.xls' could not be
found. Check the spelling of the file name, and verify that the file
location is correct.
If you are trying to open the file from your list of most recently used
files, make sure that the file has not been renamed, moved, or deleted.
Help File: C:\Program Files\Microsoft Office\Office12\1033\XLMAIN11.CHM
Help Context ID: 0"
Now, kindly suggest how to rectify above mentioned error. Thanks!
  2 件のコメント
Walter Roberson
Walter Roberson 2016 年 9 月 3 日
Make sure that C:\Users\Admin\Documents\MATLAB\myExample.xls does not already exist as a link to somewhere else, and make sure that you have write access to C:\Users\Admin\Documents\MATLAB\
MatlabUser
MatlabUser 2016 年 9 月 7 日
編集済み: MatlabUser 2016 年 9 月 7 日
Thanks for reply! I followed as per your suggestions but still facing the same problem. I guess its something related to invoking the Excel application in activex mode. However I am unable to figure out the exact cause of the problem. Also I would like to mention here that the same code is working perfectly on other PC without any issue at all..

回答 (1 件)

Sindhuja Parimalarangan
Sindhuja Parimalarangan 2016 年 9 月 6 日
This error is generated directly by Excel upon opening the file from MATLAB. You can find more information about this issue on Microsoft's website:
  1 件のコメント
MatlabUser
MatlabUser 2016 年 9 月 7 日
Thanks for reply! I have gone through the link provided. I checked the relevant registry settings in my PC. All settings seems alright but I am not able to resolve the issue. Any other option which I need to try, please let me know.

この質問は閉じられています。

Community Treasure Hunt

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

Start Hunting!

Translated by