Solved

Export a protected excel worksheet from Java

Posted on 2006-11-01
2
291 Views
Last Modified: 2012-08-14
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
Comment
Question by:Arturus
2 Comments
 
LVL 10

Accepted Solution

by:
jaggernat earned 500 total points
ID: 17864087
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
EJB MDB example 4 89
I am having a difficulty creating a responsive Page for my website. 10 87
console vs log file 16 83
JSONSerializer.toJSON in JSP generating error 8 88
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question