Solved

Export a protected excel worksheet from Java

Posted on 2006-11-01
2
287 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Javascript onclick event 4 101
issue with pdf generation 2 78
Set up Wildfly 10 8 323
How to set default webapp for host 6 41
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
A Short Story about the Best File Recovery Software – Acronis True Image 2017
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now