1.往Excel文件插入图片:
private static final double CELL_DEFAULT_HEIGHT = 17;
private static final double CELL_DEFAULT_WIDTH = 64;
private static final String GIF_OR_JPG_IMAGE_FILE = "window.gif";
public static void createExcel(){
WritableWorkbook workbook = null;
try {
workbook =Workbook.createWorkbook(new File("firstExcel.xls"));
WritableSheet sheet = workbook.createSheet("第一个Sheet", 0);
Label label = new Label(0,0,"第一行第一列");
sheet.addCell(label);
File imageFile = new File(GIF_OR_JPG_IMAGE_FILE);
BufferedImage input = ImageIO.read(imageFile);
ByteArrayOutputStream baos = new ByteArrayOutputStream();
ImageIO.write(input, "GIF", baos); //PNG JPG GIF
sheet.addImage(new WritableImage(1,1,input.getWidth() / CELL_DEFAULT_WIDTH,
input.getHeight() / CELL_DEFAULT_HEIGHT,baos.toByteArray()));
workbook.write();
} catch (IOException e) {
e.printStackTrace();
} catch (RowsExceededException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
} finally{
try {
if(workbook != null){
workbook.close();
workbook = null;
}
} catch (WriteException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
...