Skip to main content
New Participant
Dec 17, 2024 5:13 PM UTC
Question

Protected Sheets or Read Only Columns when using Export Data Store Entity to Excel

Hello

I have a template that I have created where one sheet is "protected" so that it can only be edited with a password. When I use the "Copy Document" smart service, that protection remains in the copy. However, when I use the Export Data Store Entity to Excel smart service, the protection goes away. Is there any way to keep this protection or some other way to make a sheet read-only within Excel upon completion of the Export Smart Service?

Thanks

1 reply

mathieud0001
Genius
Dec 17, 2024 10:18 PM UTC

There is an encrypt excel smart service but it seems to only work for the whole file and not individual workbooks

 [mention:3c6fbe8aec284de096659ed1a4ce1da6:f7d226abd59f475c9d224a79e3f0ec07] 

I would try to contact the authors of the plugin. Otherwise, the plugin seems to use the Apache POI library so if you feel adventurous, you could create your own fork of the plugin to implement this functionality.

poi.apache.org/.../WorksheetProtectionBlock.html