Java ClientAnchor.setDy1方法代码示例

import org.apache.poi.ss.usermodel.ClientAnchor; //导入方法依赖的package包/类
/**
 * See the comment for the given cell
 * 
 * @param cell
 *            the cell
 * @param message
 *            the comment message
 */
public static void setComment(HSSFCell cell, String message) {
	Drawing drawing = cell.getSheet().createDrawingPatriarch();
	CreationHelper factory = cell.getSheet().getWorkbook().getCreationHelper();

	// When the comment box is visible, have it show in a 1x3 space
	ClientAnchor anchor = factory.createClientAnchor();
	anchor.setCol1(cell.getColumnIndex());
	anchor.setCol2(cell.getColumnIndex() + 1);
	anchor.setRow1(cell.getRowIndex());
	anchor.setRow2(cell.getRowIndex() + 1);
	anchor.setDx1(100);
	anchor.setDx2(1000);
	anchor.setDy1(100);
	anchor.setDy2(1000);

	// Create the comment and set the text+author
	Comment comment = drawing.createCellComment(anchor);
	RichTextString str = factory.createRichTextString(message);
	comment.setString(str);
	comment.setAuthor("TURNUS");
	// Assign the comment to the cell
	cell.setCellComment(comment);
}
 

import org.apache.poi.ss.usermodel.ClientAnchor; //导入方法依赖的package包/类
/**
 * セルに対し画像を設定します。
 * @param c セル。
 * @param value 値。
 * @param p セル位置情報。
 */
private void setImage(final Cell c, final Object value, final CellPosition p) {
	ImageData img = (ImageData) value;
	int cidx = c.getColumnIndex();
	int ridx = c.getRowIndex();
	ClientAnchor anchor = new XSSFClientAnchor();
	anchor.setCol1(cidx);
	anchor.setCol2(cidx + p.getColumns());
	anchor.setRow1(ridx);
	anchor.setRow2(ridx + p.getRows());
	anchor.setDx1(XSSFShape.EMU_PER_PIXEL * p.getDx1());
	anchor.setDy1(XSSFShape.EMU_PER_PIXEL * p.getDy1());
	anchor.setDx2(XSSFShape.EMU_PER_PIXEL * p.getDx2());
	anchor.setDy2(XSSFShape.EMU_PER_PIXEL * p.getDy2());
	anchor.setAnchorType(ClientAnchor.MOVE_AND_RESIZE);
	int imgtype = XSSFWorkbook.PICTURE_TYPE_PNG;
	if (ImageData.CONTENT_TYPE_JPEG.equals(img.getContentType())) {
		imgtype = XSSFWorkbook.PICTURE_TYPE_JPEG;
	} else if (ImageData.CONTENT_TYPE_GIF.equals(img.getContentType())) {
		imgtype = XSSFWorkbook.PICTURE_TYPE_GIF;
	}
	int pidx = this.workbook.addPicture(img.getContents(), imgtype);
	Picture pic = this.drawing.createPicture(anchor, pidx);
	this.resizeImage(c, pic, p);
}
 

import org.apache.poi.ss.usermodel.ClientAnchor; //导入方法依赖的package包/类
/**
 * 抽象出图片生成业务代码
 * 
 * @throws IOException
 */
private void extractPicturePortion(String svgString, XSSFWorkbook wb,
		XSSFSheet sheet, int startCol, int endCol, int startRow, int endRow)
		throws IOException {
	// 图片
	if (org.apache.commons.lang3.StringUtils.isNotBlank(svgString)) {
		byte[] safeDataBytes = new BASE64Decoder().decodeBuffer(svgString);
		int pictureIdx = wb.addPicture(safeDataBytes,
				Workbook.PICTURE_TYPE_JPEG);
		CreationHelper helper = wb.getCreationHelper();
		// Create the drawing patriarch. This is the top level container for
		// all shapes.
		Drawing drawing = sheet.createDrawingPatriarch();
		// add a picture shape
		ClientAnchor anchor = helper.createClientAnchor();
		// set top-left corner of the picture,
		// subsequent call of Picture#resize() will operate relative to it
		anchor.setCol1(startCol);
		anchor.setCol2(endCol);
		anchor.setRow1(startRow);
		anchor.setRow2(endRow);
		anchor.setDx1(0);
		anchor.setDy1(0);
		anchor.setDx2(0);
		anchor.setDy2(0);
		anchor.setAnchorType(ClientAnchor.MOVE_DONT_RESIZE);
		Picture pict = drawing.createPicture(anchor, pictureIdx);
		pict.resize(1);
	}
}
 

import org.apache.poi.ss.usermodel.ClientAnchor; //导入方法依赖的package包/类
protected void writeHeader(Sheet sheet, Drawing drawing, Row nameRow, Row labelRow, int i, ExcelColumn column, CellStyle boldStyle)
{
  CreationHelper helper = sheet.getWorkbook().getCreationHelper();

  // Notify the listeners
  for (ExcelExportListener listener : listeners)
  {
    listener.preHeader(column);
  }

  nameRow.createCell(i).setCellValue(helper.createRichTextString(column.getAttributeName()));

  Cell cell = labelRow.createCell(i);
  cell.setCellValue(helper.createRichTextString(column.getDisplayLabel()));

  if (column.isRequired() && boldStyle != null)
  {
    cell.setCellStyle(boldStyle);
  }

  if (column.getDescription() != null && column.getDescription().length() > 0)
  {
    ClientAnchor anchor = helper.createClientAnchor();
    anchor.setDx1(0);
    anchor.setDy1(0);
    anchor.setDx2(0);
    anchor.setDy2(0);
    anchor.setCol1(0);
    anchor.setRow1(0);
    anchor.setCol2(0);
    anchor.setRow2(4);

    Comment comment = drawing.createCellComment(anchor);
    comment.setString(helper.createRichTextString(column.getDescription()));

    cell.setCellComment(comment);
  }

  sheet.autoSizeColumn((short) i);
}