| | |
|---|
| | | //图片元素 |
|---|
| | | HSSFPatriarch patriarch = sheet.createDrawingPatriarch(); |
|---|
| | | int rowNum = 1; |
|---|
| | | int rowNumAdd=27; |
|---|
| | | int rowNumAdd=25; |
|---|
| | | //插入图片 |
|---|
| | | int picNum = 0; |
|---|
| | | String[] picName = new String[]{ |
|---|
| | |
|---|
| | | sheet.createRow(rowNum - 1); |
|---|
| | | sheet.getRow(rowNum - 1).createCell(0).setCellValue(picName[i]); |
|---|
| | | HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 512, 255, (short) 0, rowNum, (short) 10, rowNum + rowNumAdd); |
|---|
| | | anchor.setAnchorType(ClientAnchor.AnchorType.DONT_MOVE_AND_RESIZE); |
|---|
| | | anchor.setAnchorType(ClientAnchor.AnchorType.MOVE_DONT_RESIZE); |
|---|
| | | patriarch.createPicture(anchor, wb.addPicture(bytes.get(picNum), HSSFWorkbook.PICTURE_TYPE_PNG)).resize(1); |
|---|
| | | picNum++; |
|---|
| | | rowNum += rowNumAdd; |
|---|
| | | rowNum = rowNum+rowNumAdd+5; |
|---|
| | | } |
|---|
| | | rowNum++; |
|---|
| | | } |
|---|
| | | } |
|---|
