POI小记

1.设置行高（实际数值乘以20）

row.setHeight((short)(120*20));

2.设置列宽（实际数值乘以256）

sheet.setColumnWidth(0, 15*256);

3.设置水平居中、垂直居中

style.setAlignment(HorizontalAlignment.CENTER); // 水平对齐
style.setVerticalAlignment(VerticalAlignment.CENTER); // 垂直对齐

4.插入图片

                            // 将图片写入流中
                            ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
                            bufferImg = ImageIO.read(new File(productLocalPic));
                            ImageIO.write(bufferImg, "jpg", byteArrayOut);

                            //图片导出到单元格中
                            XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0,
                                    (short) 6, rowIndex, (short) 6+1, rowIndex+1);
                            anchor.setAnchorType(ClientAnchor.AnchorType.MOVE_AND_RESIZE);
                            // 插入图片
                            drawingPatriarch.createPicture(anchor, book.addPicture(
                                    byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));

                            byteArrayOut.close();