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

 채택된 답변

Samer Husam
Samer Husam 2012년 6월 28일

0 개 추천

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)

추가 답변 (1개)

Samer Husam
Samer Husam 2012년 6월 28일

0 개 추천

is there a function in MATLAB
xlsprotect
can be use?

카테고리

도움말 센터File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by