Tweet
Hi,
We are using various versions of POI (Last installed version is 3.12) to generate XLS and XLSX files on IBMi. In the latest enhancement, we need to add password protection to these XLS and XLSX files. Do we perhaps have any straightforward easy way to achieve this on IBMi? Till now, we have given tries to POI setCurrentUserPassword and confirmPassword methods. They dont work on 3.12 but we created a Java class using POI 5.0.0 and that helped us with XLSX (not XLS) encryption. I am curious to know if that's how we generally do it or there are other comparatively easy ways too.
Your help and guidance in this regard will highly be appreciated. Thank you.
We are using various versions of POI (Last installed version is 3.12) to generate XLS and XLSX files on IBMi. In the latest enhancement, we need to add password protection to these XLS and XLSX files. Do we perhaps have any straightforward easy way to achieve this on IBMi? Till now, we have given tries to POI setCurrentUserPassword and confirmPassword methods. They dont work on 3.12 but we created a Java class using POI 5.0.0 and that helped us with XLSX (not XLS) encryption. I am curious to know if that's how we generally do it or there are other comparatively easy ways too.
Your help and guidance in this regard will highly be appreciated. Thank you.
Comment