xlsread with protected sheets

Does xlsread have any trouble reading protected excel sheets?

Thanks!

[Caroline]

And if it does, is there anyway to unprotect them in MATLAB?

Answer 1

[the cyclist]

There is a very old file in the File Exchange that claims to be able to protect/unprotect Excel files: http://www.mathworks.com/matlabcentral/fileexchange/6046-xlsprotect

Here is a thread on the older MATLAB newsgroup forum about this function: http://www.mathworks.com/matlabcentral/newsreader/view_thread/98978

[Caroline]

Thank you for answering me! Do you know where you have to put this file in your MATLAB directory in order for it to work?

Thanks again!

[the cyclist]

MATLAB has a "search path" where it looks for commands. You can type

path

to see what it is. The file can go anywhere in the search path.

Perhaps easiest is to put it in the top-level MATLAB directory.

[Caroline]

Thank you!

Answer 2

[ES]

xlsread is very limited. Create Excel Com objects from Matlab using ActiveX. It has every feature of matlab.

%Create Excel Sheet Object for the sheet objExcel = actxserver('Excel.Application'); objExcelS=objExcel.Workbooks.Open(fullfile(ExcelFilePath, ExcelFileName)); objExcelS.Protect. %Protection on off for current sheet

% Delete the COM object. objExcel.ActiveWorkbook.Save; objExcel.ActiveWorkbook.Close; objExcel.Quit; objExcel.delete;

Now the excel protection can be removed and xlsread can be done. Else data can be read by using the com object itself.