Protecting sheets in a generated Excel Workbook

Posted under features on August 20 , 2019 by Nidhisha Shetty

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.

ExportSheets.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.

Protect Column

Fig 1.1


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):

ExportToExcel.SK:
In Export Specifications block, a RefEdit box is provided to set the sheets password as shown in Fig 1.2.
Note: ExportToExcel applies same password to all the sheets generated.

Export Specifications

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:

Popup

Fig 1.3


To unprotect the sheet, click on Unprotect Sheet option present in the Review menu as shown in the following figure:

Unprotected Sheet

Fig 1.4


It will ask to enter the password as shown in the following figure:

Password

Fig 1.5


Once the correct password is entered, the sheets will be editable.



TAGGED:PasswordExport To ExcelExport Sheets


Recent Posts


Export To Excel Using Template

February 06, 2020 bySwanand Nirgudkar

For generating custom reports with complex formatting rules, SheetKraft's ExportToExcel Using…

Continue Reading

Export to XML

February 02, 2020 bySwanand Nirgudkar

A quick reference for exporting to an XML document through SheetKraft Any form of organized or…

Continue Reading

Display Inputs and Calculate Immediately Outputs

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

Exporting Double Quotes Within a Text File

November 19, 2019 byShubham Thakkar

When dealing with automatic messaging systems, we often have to use some conventions in our input…

Continue Reading

Let's talk

Address

7th floor, Unit No. 701, C Wing,
Kailas Business Park, S. Veer Savarkar Marg,
Park Site, Vikhroli (W), Mumbai-400079.

 

Phone

+91 22 62362043

 

For General Queries & Technical Support

contact@quantumphinance.com

 

For Sale and Demos

sales@quantumphinance.com