protect Excel Sheet in MATLAB

5 visualizzazioni (ultimi 30 giorni)
Samer Husam
Samer Husam il 27 Giu 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

Risposta accettata

Samer Husam
Samer Husam il 28 Giu 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)

Più risposte (1)

Samer Husam
Samer Husam il 28 Giu 2012
is there a function in MATLAB
xlsprotect
can be use?

Community Treasure Hunt

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

Start Hunting!

Translated by