xlswrite It may be locked by another process

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.

[mariem farhat]

Ok, I have download xlswrite1 and replace the command xlswrite by xlswrite1.

Answer 1

[Image Analyst]

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.

[Image Analyst]

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.

Answer 2

[Amr Hashem]

to save in excel sheet

 xlswrite('filename.xls',data,1)  ;  %%where data is the answer you want to save and '1' the sheet number