Skip to main content
J
joet585
December 17, 2024
Question

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

  • December 17, 2024
  • 1 reply
  • 0 views

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
mathieud0001
December 17, 2024

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

Terms & ConditionsAccessibility statement