SheetKraft provides the feature for protecting the workbook sheets by setting password.
The password can be set in both formulas ExportSheets.SK and ExportToExcel.SK.
In Choose Sheets block, while selecting sheets to export, in the Protect column, the password can be provided for each sheet. The default value is set to FALSE (Boolean), which means unprotected.
While setting up an ExportSheets formula click on formula explorer, and provide the password to the sheets based on the condition provided as shown in the following figure (Fig 1.2):
In the output generated, user can view however cannot edit the data in the protected sheets. If the user tries to access these sheets a warning will pop-up which mentions that the sheets are protected:
Once the correct password is entered, the sheets will be editable.
February 06, 2020 bySwanand Nirgudkar
For generating custom reports with complex formatting rules, SheetKraft's ExportToExcel Using…Continue Reading
February 02, 2020 bySwanand Nirgudkar
A quick reference for exporting to an XML document through SheetKraft Any form of organized or…Continue Reading
January 20, 2020 bySwanand Nirgudkar
While running an automated process, there may arise a need for the user to get some assistance on…Continue Reading