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
Discussion posts and replies are publicly visible
There is an encrypt excel smart service but it seems to only work for the whole file and not individual workbooks
Encrypt Excel Document With Password
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