フィルターのクリア

How to store my array into Excel

1 回表示 (過去 30 日間)
Abdullah Azzam
Abdullah Azzam 2017 年 10 月 22 日
コメント済み: dpb 2017 年 10 月 22 日
I have created a dummy array in order to see how the function xlswrite work bu the following error appear:
>> y= zeros [5,1]
>> xlswrite('filename.xlsx',y)
Error using xlswrite (line 220)
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Microsoft Excel cannot access the file 'C:\Program Files\MATLAB\R2013a\bin\64F1E720'. There are several possible reasons:
The file name or path does not exist.
The file is being used by another program.
The workbook you are trying to save has the same name as a currently open workbook.
Help File: xlmain11.chm
Help Context ID: 0
Thanks for the help in advance
  3 件のコメント
Abdullah Azzam
Abdullah Azzam 2017 年 10 月 22 日
I haven't tried to restart my computer, but shouldn't the xlswrite create my excel file "filename.xlsx" rather than looking for existing one?
dpb
dpb 2017 年 10 月 22 日
As Rik says, there are others besides "failing to create"; one of the other two are more likely.
I've also found that if there's ever an error in the OLE expression that the internal cleanup routine may fail and in that case I've found nothing other than restarting Matlab will recover the state. In that case, however, the error is one of an internal failure so doesn't appear to be the issue here...

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by