java excel poi 图片大小_java – POI Excel HSSFPicture图像和大小

我通过以下代码将一个图像添加到工作表中：

// Create the drawing patriarch. This is the top level container for all shapes.

Drawing drawing = sheet.createDrawingPatriarch();

//add a picture shape

//ClientAnchor anchor = this.creationHelper.createClientAnchor();

ClientAnchor anchor = new HSSFClientAnchor((short)0, (short)0, (short)0, (short)0, (short)0, (short)0, (short)2, (short)5)

// 0 = Move and size with Cells, 2 = Move but don't size with cells, 3 = Don't move or size with cells.

anchor.setAnchorType(2)

HSSFPicture pict = drawing.createPicture(anchor, this.images.get("logo"));

pict.resize() ;

然而,在添加图像之后,我调整了列的大小 – 这似乎搞砸了.它调整了图像的大小 – 这不是我想要的.

//psuedo code

public void autoSizeColumns() {

def cols = (StartColumn..this.cMax)

cols.each { i ->

sheet.autoSizeColumn i

}

}

BrandedWorksheet v;

v.autoSizeColumns()

如果我不执行autoSizeColumns(),则图像大小合适.

有没有办法让两者都有？