xlsread with protected sheets
显示 更早的评论
Does xlsread have any trouble reading protected excel sheets?
Thanks!
采纳的回答
the cyclist
2013-8-22
1 个投票
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 个评论
Caroline
2013-8-22
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.
Caroline
2013-8-22
更多回答（1 个）
ES
2013-8-23
0 个投票
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.
类别
在 帮助中心 和 File Exchange 中查找有关 Environment and Settings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
