>> >> Try swtiching to org.apache.poi.hssf.util.CellRangeAddress >> >> Regards, >> Dave >> >> On May 7, 2010, at 4:43 PM, Erwin Kalvelagen wrote: >> >>> I was using org.apache.poi.hssf.util.RangeAddress extensively with an older >>> version of POI. This seems not there anymore in the current version (3.6). > Did >>> this functionality to a different class? >>> >>> Thanks, Erwin >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: user-unsubscribe <at> poi.apache.org >>> For additional commands, e-mail: user-help <at> poi.apache.org >>> >> > > > Thanks for the quick reply. The suggested class does not take a constructor > with > a string containing the range: > > public RangeAddress (String _url) > > There is another one called AreaReference, but that seems to miss things like: > > public boolean hasSheetName () > > So neither of these are (good enough) replacements for RangeAddress.
AreaReference should work if you getCells() and use CellReference's getSheetName() http://www.javadocexamples.com/org/apache/poi/hssf/util/org.apache.poi.hssf.util.AreaReference.html http://poi.apache.org/apidocs/org/apache/poi/hssf/util/CellReference.html http://www.javadocexamples.com/org/apache/poi/hssf/util/org.apache.poi.hssf.util.CellReference.html Regards, Dave --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
