> CellRangeAddress cellRangeAddress = sheet.getMergedRegion(i);
Just drop the data type declarations in front of the variable names. Then
instantiate classes with init() instead of "new ClassName( ...)". You may also
want to break it up for better readability. I am heading out and cannot test
this, but something along these lines:
// not tested
cellRangeAddress = sheet.getMergedRegion(i);
firstRow = newRow.getRowNum();
lastRow = newRow.getRowNum() + (cellRangeAddress.getFirstRow() -
cellRangeAddress.getLastRow());
firstCol = cellRangeAddress.getFirstColumn();
lastCol = cellRangeAddress.getLastColumn();
cellRangeAddress = createObject("java",
"org.apache.poi.hssf.util.CellRangeAddress");
cellRangeAddress = cellRangeAddress.init( f
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351522
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
