Re: Poi linking to other spreadsheets

[DLee@xxxxxxxx]

JK

Thanks for your reply.  I currently also use Klements stuff, and have done 
several workbooks using formulas, and have really enjoyed using the 
product.

My problem this time, is I want to link the cells in several sheets, in 
the same workbook and bring the total of those cells to a cell in the 
final sheet.

NAIC10, NAIC12, NAIC14, NAIC16 are the sheets I want to link to.

Normally, I would do the following to get the cell address, and create a 
formula.

gwp02_c    = hssf_cellname( rowcount: 2)
gwp12_c    = hssf_cellname( rowcount: 12)
hssf_formula( row:14: 'SUM('+gwp02_c +':'+gwp12_c +')':Numeric);  

Since sheet names are involved, I don't know how to code it. 

Below is an example of how the formula would look in sheet NAIC18, in cell 
O9 using ms excel. 
Notice in the example below NAIC10 is a sheet name, and O9 is a cell in 
that sheet, and so on.

=(NAIC10!O9+NAIC12!O9+NAIC14!O9+NAIC16!O9)

Appreciate your help and comment.