本文整理汇总了Java中org.apache.poi.hssf.usermodel.HSSFShape类的典型用法代码示例。如果您正苦于以下问题:Java HSSFShape类的具体用法?Java HSSFShape怎么用?Java HSSFShape使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
HSSFShape类属于org.apache.poi.hssf.usermodel包,在下文中一共展示了HSSFShape类的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getSheetPictrues03
import org.apache.poi.hssf.usermodel.HSSFShape; //导入依赖的package包/类
/**
* 获取Excel2003图片
*
* @param sheet
* 当前sheet对象
* @param workbook
* 工作簿对象
* @return Map key:图片单元格索引(1_1)String,value:图片流PictureData
*/
public static Map<String, PictureData> getSheetPictrues03(HSSFSheet sheet,
HSSFWorkbook workbook) {
Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
List<HSSFPictureData> pictures = workbook.getAllPictures();
if (!pictures.isEmpty()) {
for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {
HSSFClientAnchor anchor = (HSSFClientAnchor) shape.getAnchor();
if (shape instanceof HSSFPicture) {
HSSFPicture pic = (HSSFPicture) shape;
int pictureIndex = pic.getPictureIndex() - 1;
HSSFPictureData picData = pictures.get(pictureIndex);
String picIndex = String.valueOf(anchor.getRow1()) + "_"
+ String.valueOf(anchor.getCol1());
sheetIndexPicMap.put(picIndex, picData);
}
}
return sheetIndexPicMap;
} else {
return sheetIndexPicMap;
}
}
示例2: getSheetPictrues03
import org.apache.poi.hssf.usermodel.HSSFShape; //导入依赖的package包/类
/**
* 获取Excel2003图片
*
* @param sheet
* 当前sheet对象
* @param workbook
* 工作簿对象
* @return Map key:图片单元格索引(1_1)String,value:图片流PictureData
*/
public static Map<String, PictureData> getSheetPictrues03(HSSFSheet sheet, HSSFWorkbook workbook) {
Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
List<HSSFPictureData> pictures = workbook.getAllPictures();
if (!pictures.isEmpty()) {
for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {
HSSFClientAnchor anchor = (HSSFClientAnchor) shape.getAnchor();
if (shape instanceof HSSFPicture) {
HSSFPicture pic = (HSSFPicture) shape;
int pictureIndex = pic.getPictureIndex() - 1;
HSSFPictureData picData = pictures.get(pictureIndex);
String picIndex = String.valueOf(anchor.getRow1()) + "_"
+ String.valueOf(anchor.getCol1());
sheetIndexPicMap.put(picIndex, picData);
}
}
return sheetIndexPicMap;
} else {
return null;
}
}
示例3: processSheetImage
import org.apache.poi.hssf.usermodel.HSSFShape; //导入依赖的package包/类
private void processSheetImage(Element htmlBody, HSSFSheet sheet) {
// Element h2 = htmlDocumentFacade.createImage(logo);
// h2.setAttribute("style", "top:112px;left:300px;position:absolute");
// htmlBody.appendChild( h2 );
if (sheet.getDrawingPatriarch() != null) {
final List<HSSFShape> shapes = sheet.getDrawingPatriarch()
.getChildren();
for (int i = 0; i < shapes.size(); ++i) {
if (shapes.get(i) instanceof HSSFPicture) {
try {
// Gain access to private field anchor.
final HSSFPicture pic = (HSSFPicture) shapes.get(i);
picMap.put(pic.getPreferredSize().getCol1()+":"+pic.getPreferredSize().getRow1(), pic);
} catch (final Exception e) {
throw new RuntimeException(e);
}
}
}
}
}
示例4: table
import org.apache.poi.hssf.usermodel.HSSFShape; //导入依赖的package包/类
private void table(final HSSFSheet sheet) {
if (sheet == null) {
return;
}
if (sheet.getDrawingPatriarch() != null) {
final List<HSSFShape> shapes = sheet.getDrawingPatriarch()
.getChildren();
for (int i = 0; i < shapes.size(); ++i) {
if (shapes.get(i) instanceof HSSFPicture) {
try {
// Gain access to private field anchor.
final HSSFShape pic = shapes.get(i);
final Field f = HSSFShape.class
.getDeclaredField("anchor");
f.setAccessible(true);
final HSSFClientAnchor anchor = (HSSFClientAnchor) f
.get(pic);
// Store picture cell row, column and picture data.
if (!pix.containsKey(anchor.getRow1())) {
pix.put(anchor.getRow1(),
new HashMap<Short, List<HSSFPictureData>>());
}
if (!pix.get(anchor.getRow1()).containsKey(
anchor.getCol1())) {
pix.get(anchor.getRow1()).put(anchor.getCol1(),
new ArrayList<HSSFPictureData>());
}
pix.get(anchor.getRow1())
.get(anchor.getCol1())
.add(book.getAllPictures().get(
((HSSFPicture) pic).getPictureIndex()));
} catch (final Exception e) {
throw new RuntimeException(e);
}
}
}
}
out.append("<table cellspacing='0' style='border-spacing:0; border-collapse:collapse;'>\n");
for (rowIndex = 0; rowIndex < sheet.getPhysicalNumberOfRows(); ++rowIndex) {
tr(sheet.getRow(rowIndex));
}
out.append("</table>\n");
}