import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class FormulaTest {
    
    public static void main(String[] args) {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet();
        HSSFRow row = sheet.createRow(0);
        
        // A1
        HSSFCell cell = row.createCell((short)0);
        
        cell.setCellValue(5);
        cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
        
        // B1
        row = sheet.createRow(1);
        cell = row.createCell((short)0);
        
        for (int i = 0; i < 5; i++) {
            cell.setCellFormula("A1*" + i);
            System.out.println(cell.getCellFormula());
        }
        
        
        try {
            FileOutputStream outStream = new FileOutputStream("formulatest.xls");
            wb.write(outStream);
            outStream.close();
        }
        catch (IOException ex) {
            ex.printStackTrace();
        }
        
    }
    
}