protect Excel Sheet in MATLAB

8 views (last 30 days)
Samer Husam
Samer Husam on 27 Jun 2012
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

Accepted Answer

Samer Husam
Samer Husam on 28 Jun 2012
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)

More Answers (1)

Samer Husam
Samer Husam on 28 Jun 2012
is there a function in MATLAB
xlsprotect
can be use?

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!