Solved

Export a protected excel worksheet from Java

Posted on 2006-11-01
2
292 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
jaggernat earned 500 total points
ID: 17864087
0

Featured Post

Industry Leaders: 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

A big percent of today’s marketing activity is performed through the online environment. The marketing strategies that have existed a decade ago no longer relate to what’s happening today. We’re currently facing a revolutionary era, called the digit…
Check out this step-by-step guide for asking an anonymous question on Experts Exchange.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

734 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