xlsread with protected sheets

3 次查看(过去 30 天)
Does xlsread have any trouble reading protected excel sheets?
Thanks!
  1 个评论
Caroline
Caroline 2013-8-22
And if it does, is there anyway to unprotect them in MATLAB?

请先登录,再进行评论。

采纳的回答

the cyclist
the cyclist 2013-8-22
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
  3 个评论
the cyclist
the cyclist 2013-8-22
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.

请先登录,再进行评论。

更多回答(1 个)

ES
ES 2013-8-23
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.

Community Treasure Hunt

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

Start Hunting!

Translated by