Protect or unprotect worksheets in Excel file

版本 1.1.0.0 (3.8 KB) 作者: Guilherme Coco Beltramini
Protect or unprotect selected worksheets in Excel file, with or without password
0.0
(0)
686.0 次下载
更新时间 2013/6/3

查看许可证

USAGE
xls_protect_sheets(xlsfile,sheets,action)
xls_protect_sheets(xlsfile,sheets,action,password)

INPUT
- XLSFILE: name of the Excel file
- SHEETS: cell array with the worksheet names, or matrix with positive integers, or 'all', to tell which worksheets are going to be protected
- ACTION: 'protect' or 'unprotect'
- PASSWORD: password to protect or unprotect the worksheet

OUTPUT
- XLSFILE will be edited

引用格式

Guilherme Coco Beltramini (2024). Protect or unprotect worksheets in Excel file (https://www.mathworks.com/matlabcentral/fileexchange/42055-protect-or-unprotect-worksheets-in-excel-file), MATLAB Central File Exchange. 检索时间: .

MATLAB 版本兼容性
创建方式 R2010a
兼容任何版本
平台兼容性
Windows macOS Linux
类别
在 Help Center 和 MATLAB Answers 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

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

Start Hunting!

版本 已发布 发行说明
1.1.0.0

Added missing function
1.0.0.0