xlsProtect: Password Protect Excel Files through Matlab

バージョン 1.0.0 (2.28 KB) 作成者: Ehtisham
This code will save the file (.xls or .xlsx) after adding "_protected" at the end of the original name of the file and with .xls extension.
ダウンロード: 66
更新 2021/6/28

ライセンスの表示

xlsProtect: Password Protect Excel Files to avoid any editing.
Developed by Ehtisham: your.radical.tutor@gmail.com
Format: xlsProtect (Filename, password);
This code will save the file (.xls or .xlsx) after adding "_protected" at the end of the original name of the file and with .xls extension only. The original file will not be changed, however, the new file will be protected with the password your will provide in the 2nd arugment of the function.
Both workbook and worksheet will be protected for any format change or any value editing. Files can be unprotected by going to Review Tab in Excel File and usign Commands Unprotect Sheet and Unprotect Workbook after providing the password which you used to protect the file.
You may save the file with new version by changing the extension from .xls to .xlsx. I am working on this issue and will update the code as soon as possible.
1st Argument:
Filename is the Microsoft Excel file which is to be protected, specifying full path
FILE NAMES MUST BE FULL PATH NAMES i.e. 'C:\Users\Desktop\User\example.xls'
2nd Argument:
password will be the password of your choice (string) or Number (integer) to protect the files from any editing. This password will be requierd while unprotecting the files as well.
Examples:
xlsProtect('C:\Users\Desktop\User\example.xls','mypassword123');
xlsProtect('C:\Users\Desktop\User\example.xlsx','mypassword123');

引用

Ehtisham (2024). xlsProtect: Password Protect Excel Files through Matlab (https://www.mathworks.com/matlabcentral/fileexchange/94983-xlsprotect-password-protect-excel-files-through-matlab), MATLAB Central File Exchange. 取得済み .

MATLAB リリースの互換性
作成: R2014b
R2014b 以降のリリースと互換性あり
プラットフォームの互換性
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!
バージョン 公開済み リリース ノート
1.0.0