On 4/20/2010 3:35 PM, Steve Wolke wrote:
I think you can use the CellReference class and the formatAsString
method.
http://poi.apache.org/apidocs/org/apache/poi/ss/util/CellReference.html#
formatAsString()
Works like a charm...
Thx,
-RFH
---------------------
CellReference cellRef;
cellRef = new CellReference(15, 10);
String alphaNumericBegin = cellRef.formatAsString();
cellRef = new CellReference(15 + nofTubes - 1, 10);
String alphaNumericEnd = cellRef.formatAsString();
cell.cellValue = "SUM("+alphaNumericBegin+":"+alphaNumericEnd+")";
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
