组合框ComBoBox

1.组合框

package hssf.shape.simpleshape;

import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFShape;
import org.apache.poi.hssf.usermodel.HSSFSimpleShape;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

/**
 * 直线在sheet中位置
 * new HSSFClientAnchor(x1, y1, x2, y2, (short)startcol, startrow, (short)endcol, endrow)
 * @param x1     直线一端在开始单元格(startcol, startrow)内的横坐标，范围[0, 2013],将列宽均分为1023份
 * @param y1     直线一端在开始单元格(startcol, startrow)内的纵坐标，范围[0, 255],将行高均分为255份
 * @param x2    直线一端在结束单元格(endcol, endrow)内的横坐标，范围[0, 2013],将列宽均分为1023份
 * @param y2    直线一端在结束单元格(endcol, endrow)内的纵坐标，范围[0, 255],将列宽均分为255份
 * @param startcol 直线一端所处开始列号，base 0
 * @param startrow 直线一端所处开始行号，base 0
 * @param endcol   直线另一端所处结束列号，base 0
 * @param endrow   直线另一端所处结束行号，base 0
 * */ 
public class TestCombobox {

	public static void main(String[] args) throws IOException {
		// 创建一个工作博
		Workbook workbook = new HSSFWorkbook();
		// 创建一个sheet
		Sheet sheet = workbook.createSheet();
		// 画图的顶级管理器对象HSSFPatriarch, 一个sheet只能获取一个
		HSSFPatriarch hssfPatriarch = (HSSFPatriarch) sheet.createDrawingPatriarch();
				
		HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, (short)1, 2, (short)8, 18);
		// 创建一个组合框
		HSSFSimpleShape combobox = hssfPatriarch.createSimpleShape(anchor);
		
		combobox.setShapeType(HSSFSimpleShape.OBJECT_TYPE_COMBO_BOX);
		combobox.setFillColor(255, 0, 0);
		
		FileOutputStream file = new FileOutputStream("C://Users//Administrator//Desktop//test.xls");
		workbook.write(file);
		file.close();

	}

}