×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hiya Steve!
I must admit that it has been a long time (10 or 11 years) since I've
done anything serious with POI or XSSF. But I took a quick look
starting here:
https://poi.apache.org/apidocs/index.html
From there, I looked at 3.17, since its the closest to the level you're
at now. In the list of "All Classes" in the bottom left, I found the
"Sheet" interface. (there are two, one ends with 'sl.Sheet' the other
with 'ss.Sheet'. 'ss' for spreadsheet is the one you want.)
Within that, there appears to be a protectSheet() method, similar to
your prototype. (Your prototypes were missing part of the qualified
interface name -- I assume this was a copy/paste error rather than a
'real' problem.)
So my conclusion is that these methods do exist, at least in 3.17. I
realize that 3.6 is significantly older, and you may have to adjust the
code (POI often breaks compatibility with releases) but the adjustments
for 3.17 are bound to be much smaller than the adjustments for 5.0.
Hope that helps!
On 6/25/2021 11:40 AM, Steve M. Jones via RPG400-L wrote:
After looking into this some more, I figured out why it will not work with xlsx.
I ran this command STRQSH CMD('javap -s org.apache.poi.ss.usermodel.Sheet > /tmp/sheetmth.txt) and protectsheet is not in our version
We are using /Java/poi3.6
Does someone have a method of updating to the latest POI version, which looks to be 5.0 now
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
