xlsProtect: Password Protect Excel Files through Matlab

版本 1.0.0 (2.3 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.

关注

0.0

(0)

69.0 次下载

更新时间 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. 检索来源 2024/7/27.