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();
}
}