xlswrite It may be locked by another process

26 次查看（过去 30 天）
mariem farhat
mariem farhat 2015-7-25
评论： Image Analyst 2015-7-25
Hello,
I write this code to save information into excel file within a loop function:
Excel = actxserver ('Excel.Application');
xlsfile = 'E:\Thèse\réalisation\F.xlsx' ;
invoke(Excel.Workbooks,'Open',xlsfile);
for ifile = 3:nfiles-1
d = value;
xlswrite(xlsfile, d, 'Translation',strcat('B',num2str(ifile)));
invoke(Excel.ActiveWorkbook,'Save');
end
invoke(Excel.ActiveWorkbook,'Save');
Excel.Quit
Excel.delete
clear Excel
and this code give the following error: It may be locked by another process.

请先登录，再回答此问题。

回答（2 个）

Image Analyst
Image Analyst 2015-7-25
You already have the file open. It's possible that you don't see it because the Excel server might not be visible. Type control-shift-Esc and see if you see Excel in the Process list. If you do, kill that process. Then try again.
  1 个评论
Image Analyst
Image Analyst 2015-7-25
xlswrite() actually launches Excel and tries to open the file. So if you have the file already opened in Excel, even though you launched it via ActiveX, you won't be able to write to it because the ActiveX process has ahold of it. So, like you said, you need to use xlswrite1(), available from the File Exchange, which will use ActiveX to write to it and won't try to open it again.
For others who are interested, I'm attaching my Excel demo that uses ActiveX and xlswrite1.

请先登录，再进行评论。

Amr Hashem
Amr Hashem 2015-7-25
to save in excel sheet
xlswrite('filename.xls',data,1) ; %%where data is the answer you want to save and '1' the sheet number

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by