I am aware that this plugin can let me create a workbook and select worksheets to be protected, but is there a way to password protect the entire sheet?
Retrying, the upload seem stuck...
It was my problem before, you may use BigZip extension to password protect your file if you really need it.
https://www.outsystems.com/forge/component-overview/356/bigzip
Edwin Siruma wrote:
This is an option, but I have done work on the protection aspect and the password protection at a worksheet level should work now.
Hanno wrote:
I agree.
Worksheet protection is available on ExcelPackage extension. I thought you need a workbook level of data protection.
Look for ExcelPackage extension.
Yelun, with the latest version you should be able to protect the entire sheet with a password.
Excel Package link:
https://www.outsystems.com/forge/component-overview/1044/excel-package or this https://www.outsystems.com/forge/component-overview/3943/excel-package-extension
You might need to remove Advanced Excel to install this extension.
Ah my mistake, I meant that I needed the ability to protect the entire excel workbook, instead of just one worksheet
Okay, I will add support for it in Advanced Excel.
Yelun, please try the attached and let me know if it solves your problem?
Hi Hanno, just want to ask if this is OutSystems 10 compatible?
Yelun Yang wrote:
I do not have access to a P10 environment, but will try and get a P10 version built today.
Hi Hanno,
How is the P10 version coming along?
Great!
Possible to update your Excel Package extension, with multiple worksheet option when creating a workbook?
Thank you!
-Edwin
You want to create a new workbook with multiple sheets, by specifying sheet names or the number of sheets?
I wanted to have this:
Last time I downloaded the Advanced Excel extension it does not have input parameter for NumberOfSheets.
Correct me if the ExcelPackage included in the extension already has this parameter.
Thank you.
Edwin, check out the new version
Great! Thanks!
Hi Yelun
I haven't yet been able to find a P10 platform I can use for this. Hoping to receive some help from a contact or two shortly...
Regards
Hanno
Hi everyone,
See attached a P10 version of the latest P11 version (2.1.23). I tried uploading it as a new version, but the Forge refuses it:
I'll try to get that sorted out, but in the meantime you can install the attached package.
(That is, I hope you can, since I'm not entirely sure the IP is scrubbed when uploading like this. Also, I didn't test it, so if anything's wrong just let me know.)
Thank you, Killian, for helping out here!