Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

Export a protected excel worksheet from Java

Hello Experts,
I've got an interesting one...  I have a use case where an Excel file is created from a Java application.  We want to protect the sheet using a password, but allow functionality such as sorting, autofiltering and deleting rows.

I've gotten as far as protecting certain columns and allowing edit on other columns using the POI library.  However, allowing the other functionality is not possible with POI.  Macros are out, as the spreadsheet will be e-mailed and macro's are typically blocked by most anti-virus or mail filtering programs.

Any suggestions?!!
0
Arturus
Asked:
Arturus
1 Solution
 
jaggernatCommented:
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now