Clear Filters
Clear Filters

xlswrite It may be locked by another process

29 views (last 30 days)
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.
  1 Comment
mariem farhat
mariem farhat on 25 Jul 2015
Ok, I have download xlswrite1 and replace the command xlswrite by xlswrite1.

Sign in to comment.

Answers (2)

Image Analyst
Image Analyst on 25 Jul 2015
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 Comment
Image Analyst
Image Analyst on 25 Jul 2015
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.

Sign in to comment.


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

Tags

Community Treasure Hunt

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

Start Hunting!