protect Excel Sheet in MATLAB

Question

Samer Husam 2012-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42158-protect-excel-sheet-in-matlab

hi; I have some values that is saved in Excel by MATLAB. so I want to lock or protect the sheet before its been open to the user to not allow the use to edit it. is there any way to do this ? please help and advice. thanks

Sam

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Samer Husam 2012-6-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42158-protect-excel-sheet-in-matlab#answer_51978

在 MATLAB Online 中打开

   xlsprotect(file,'protect_file',pwd2open,pwd2modify,read_only_recommended,create_backup)
 xlsprotect(file,'unprotect_file',pwd2open) 
 xlsprotect(file,'unprotect_file',pwd2open,pwd2modify)
 xlsprotect(file,'protect_sheet',sheetname,password) 
 xlsprotect(file,'protect_sheet',sheetname,password,s_options) 
 xlsprotect(file,'protect_sheet',sheetname,s_options) 
 xlsprotect(file,'protect_sheet',sheetname)
 xlsprotect(file,'unprotect_sheet',sheetname) 
 xlsprotect(file,'unprotect_sheet',sheetname,password)
 xlsprotect(file,'protect_workbook',password) 
 xlsprotect(file,'protect_workbook')
 xlsprotect(file,'unprotect_workbook') 
 xlsprotect(file,'unprotect_workbook',password)