POI保存excel时IndexOutOfBoundsException

0 0

POI保存excel时IndexOutOfBoundsException0

// 创建报告sheet
			hssfWorkbook.createSheet("report");
			HSSFSheet newSheet = hssfWorkbook.getSheetAt(templateSheetIndex + 1);
			this.copyRows(hssfWorkbook, templateSheet, newSheet, templateSheet.getFirstRowNum(), lastSheetRow, 0);
			// 设置列宽
			HSSFRow _hssfRow = templateSheet.getRow(0);
			int columnNum = _hssfRow.getPhysicalNumberOfCells();
			for (int i = 0; i < columnNum; i++) {
				newSheet.setColumnWidth(i, templateSheet.getColumnWidth(i));
			}
			System.out.println("设置列宽完成");
			
			// 复制图片
			this.copyPictures(hssfWorkbook, pictures, templateSheetIndex, newSheet, 0);
			
			String reportPath = "E:/workspace/" + new Date().getTime() + ".xls";

			// 导出巡检报告
			fileOutputStream = new FileOutputStream(new File(reportPath));
			hssfWorkbook.write(fileOutputStream);

当执行hssfWorkbook.write()时会报数组越界异常，异常信息如下：

java.lang.IndexOutOfBoundsException: Index: 2, Size: 1
	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
	at java.util.ArrayList.get(ArrayList.java:322)
	at org.apache.poi.hssf.model.DrawingManager2.getDrawingGroup(DrawingManager2.java:125)
	at org.apache.poi.hssf.model.DrawingManager2.allocateShapeId(DrawingManager2.java:71)
	at org.apache.poi.hssf.record.EscherAggregate.convertPatriarch(EscherAggregate.java:988)
	at org.apache.poi.hssf.record.EscherAggregate.convertUserModelToRecords(EscherAggregate.java:821)
	at org.apache.poi.hssf.record.EscherAggregate.getRecordSize(EscherAggregate.java:508)
	at org.apache.poi.hssf.model.InternalSheet.preSerialize(InternalSheet.java:1567)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1285)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1205)

当去掉复制图片这一行时，就一切正常：

// 复制图片
this.copyPictures(hssfWorkbook, pictures, templateSheetIndex, newSheet, 0);

下面是复制图片的方法：

private void copyPictures(HSSFWorkbook workbook, List<MyPictureData> pictures, int sourceSheetIndex, HSSFSheet targetSheet, int pPosition) {
		// 画图的顶级管理器，一个sheet只能有一个
		HSSFPatriarch patriarch = targetSheet.createDrawingPatriarch();
		
		for (MyPictureData data : pictures) {
			// 只复制指定sheet中的图片
			if (data.getSheetIndex() == sourceSheetIndex) {
				HSSFPictureData pictureData = data.getPictureData();
				int dx1 = data.getDx1();
				int dy1 = data.getDy1();
				int dx2 = data.getDx2();
				int dy2 = data.getDy2();
				short col1 = data.getCol1();
				int row1 = data.getRow1();
				short col2 = data.getCol2();
				int row2 = data.getRow2();
				
				// anchor主要用于设置图片的属性
				HSSFClientAnchor anchor = new HSSFClientAnchor(dx1, dy1, dx2, dy2, col1, row1 + pPosition, col2, row2 + pPosition);
	            // 0 = Move and size with Cells, 2 = Move but don't size with cells, 3 = Don't move or size with cells
	            anchor.setAnchorType(3);
	            // 插入图片  
	            patriarch.createPicture(anchor, workbook.addPicture(pictureData.getData(), pictureData.getFormat()));
			}
		}
	}

不知道是哪里的问题？求指点，谢谢咯。