Refer to the following example code to protect the workbook from modification using password. This option is supported only in Excel 2007, Excel 2010, Excel for Mac 2011 and Excel 2016 for Mac. Its default value is false. If windows is true, the workbook window cannot be moved, resized, closed or hidden or unhidden.If structure is true, worksheets cannot be added, moved, deleted, hidden or renamed, and hidden worksheets cannot be viewed. Its default value is true.The Workbook class provides two overloaded Protect methods, one of which takes password as a parameter. Both the methods have two optional parameters, structure and windows, which provide different types of modification protection when set. Optionally, a password can be set to achieve the same. GcExcel allows you to protect a workbook from modification. XlsxSaveOptions options = new XlsxSaveOptions() Select Unprotect Sheet or Unprotect Workbook. If you are the owner of the file, or you know the password for it, you can unprotect the file by following these steps: Select the Review tab. Save the Excel file and protect it using password. If you don’t have access to such a device, you can edit the cells in Excel for Mac if the worksheet or workbook is unprotected.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |