protect Excel Sheet in MATLAB

5 visualizaciones (últimos 30 días)
Samer Husam
Samer Husam el 27 de Jun. de 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

Respuesta aceptada

Samer Husam
Samer Husam el 28 de Jun. de 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)

Más respuestas (1)

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

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by