org.apache.poi.xssf.usermodel.XSSFDrawing.getSheet()方法的使用及代码示例

x33g5p2x  于2022-02-03 转载在 其他  
字(4.4k)|赞(0)|评价(0)|浏览(138)

本文整理了Java中org.apache.poi.xssf.usermodel.XSSFDrawing.getSheet()方法的一些代码示例,展示了XSSFDrawing.getSheet()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。XSSFDrawing.getSheet()方法的具体详情如下:
包路径:org.apache.poi.xssf.usermodel.XSSFDrawing
类名称:XSSFDrawing
方法名:getSheet

XSSFDrawing.getSheet介绍

暂无

代码示例

代码示例来源:origin: org.apache.poi/poi-ooxml

private XSSFAnchor getAnchorFromParent(XmlObject obj) {
  XSSFAnchor anchor = null;
  XmlObject parentXbean = null;
  XmlCursor cursor = obj.newCursor();
  if (cursor.toParent()) {
    parentXbean = cursor.getObject();
  }
  cursor.dispose();
  if (parentXbean != null) {
    if (parentXbean instanceof CTTwoCellAnchor) {
      CTTwoCellAnchor ct = (CTTwoCellAnchor) parentXbean;
      anchor = new XSSFClientAnchor(ct.getFrom(), ct.getTo());
    } else if (parentXbean instanceof CTOneCellAnchor) {
      CTOneCellAnchor ct = (CTOneCellAnchor) parentXbean;
      anchor = new XSSFClientAnchor(getSheet(), ct.getFrom(), ct.getExt());
    } else if (parentXbean instanceof CTAbsoluteAnchor) {
      CTAbsoluteAnchor ct = (CTAbsoluteAnchor) parentXbean;
      anchor = new XSSFClientAnchor(getSheet(), ct.getPos(), ct.getExt());
    }
  }
  return anchor;
}

代码示例来源:origin: org.apache.poi/poi-ooxml

public XSSFComment createCellComment(ClientAnchor anchor) {
  XSSFClientAnchor ca = (XSSFClientAnchor) anchor;
  XSSFSheet sheet = getSheet();

代码示例来源:origin: org.apache.poi/poi-ooxml

private CTTransform2D createXfrm(XSSFClientAnchor anchor) {
  CTTransform2D xfrm = CTTransform2D.Factory.newInstance();
  CTPoint2D off = xfrm.addNewOff();
  off.setX(anchor.getDx1());
  off.setY(anchor.getDy1());
  XSSFSheet sheet = getSheet();
  double widthPx = 0;
  for (int col = anchor.getCol1(); col < anchor.getCol2(); col++) {
    widthPx += sheet.getColumnWidthInPixels(col);
  }
  double heightPx = 0;
  for (int row = anchor.getRow1(); row < anchor.getRow2(); row++) {
    heightPx += ImageUtils.getRowHeightInPixels(sheet, row);
  }
  long width = Units.pixelToEMU((int) widthPx);
  long height = Units.pixelToEMU((int) heightPx);
  CTPositiveSize2D ext = xfrm.addNewExt();
  ext.setCx(width - anchor.getDx1() + anchor.getDx2());
  ext.setCy(height - anchor.getDy1() + anchor.getDy2());
  // TODO: handle vflip/hflip
  return xfrm;
}

代码示例来源:origin: org.apache.poi/poi-ooxml

@Override
public XSSFObjectData createObjectData(ClientAnchor anchor, int storageId, int pictureIndex) {
  XSSFSheet sh = getSheet();
  PackagePart sheetPart = sh.getPackagePart();
  XSSFSheet sheet = getSheet();
  XSSFWorkbook wb = sheet.getWorkbook();
  int sheetIndex = wb.getSheetIndex(sheet);

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

private XSSFAnchor getAnchorFromParent(XmlObject obj) {
  XSSFAnchor anchor = null;
  XmlObject parentXbean = null;
  XmlCursor cursor = obj.newCursor();
  if (cursor.toParent()) {
    parentXbean = cursor.getObject();
  }
  cursor.dispose();
  if (parentXbean != null) {
    if (parentXbean instanceof CTTwoCellAnchor) {
      CTTwoCellAnchor ct = (CTTwoCellAnchor) parentXbean;
      anchor = new XSSFClientAnchor(ct.getFrom(), ct.getTo());
    } else if (parentXbean instanceof CTOneCellAnchor) {
      CTOneCellAnchor ct = (CTOneCellAnchor) parentXbean;
      anchor = new XSSFClientAnchor(getSheet(), ct.getFrom(), ct.getExt());
    } else if (parentXbean instanceof CTAbsoluteAnchor) {
      CTAbsoluteAnchor ct = (CTAbsoluteAnchor) parentXbean;
      anchor = new XSSFClientAnchor(getSheet(), ct.getPos(), ct.getExt());
    }
  }
  return anchor;
}

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

public XSSFComment createCellComment(ClientAnchor anchor) {
  XSSFClientAnchor ca = (XSSFClientAnchor) anchor;
  XSSFSheet sheet = getSheet();

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

private CTTransform2D createXfrm(XSSFClientAnchor anchor) {
  CTTransform2D xfrm = CTTransform2D.Factory.newInstance();
  CTPoint2D off = xfrm.addNewOff();
  off.setX(anchor.getDx1());
  off.setY(anchor.getDy1());
  XSSFSheet sheet = getSheet();
  double widthPx = 0;
  for (int col = anchor.getCol1(); col < anchor.getCol2(); col++) {
    widthPx += sheet.getColumnWidthInPixels(col);
  }
  double heightPx = 0;
  for (int row = anchor.getRow1(); row < anchor.getRow2(); row++) {
    heightPx += ImageUtils.getRowHeightInPixels(sheet, row);
  }
  long width = Units.pixelToEMU((int) widthPx);
  long height = Units.pixelToEMU((int) heightPx);
  CTPositiveSize2D ext = xfrm.addNewExt();
  ext.setCx(width - anchor.getDx1() + anchor.getDx2());
  ext.setCy(height - anchor.getDy1() + anchor.getDy2());
  // TODO: handle vflip/hflip
  return xfrm;
}

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

@Override
public XSSFObjectData createObjectData(ClientAnchor anchor, int storageId, int pictureIndex) {
  XSSFSheet sh = getSheet();
  PackagePart sheetPart = sh.getPackagePart();
  XSSFSheet sheet = getSheet();
  XSSFWorkbook wb = sheet.getWorkbook();
  int sheetIndex = wb.getSheetIndex(sheet);

相关文章