导出Excel

最新推荐文章于 2024-07-23 21:45:09 发布

青春有幸

最新推荐文章于 2024-07-23 21:45:09 发布

阅读量109

点赞数

文章标签： java

原文链接：https://blog.csdn.net/xujiangdong1992/article/details/78068617

版权

首项需要的jar包有：

1.poi-3.8-20120326.jar
2.commons-codec-1.10.jar

实现：

/**
 * @param dx1 x起始坐标
 * @param dy1 y起始坐标
 * @param dx2 x结束坐标
 * @param dy2 y结束坐标
 * @param col1 起始列
 * @param row1 起始行
 * @param col2 结束列
 * @param row2 结束行
 */
private void setPicture(HSSFWorkbook workbook, HSSFSheet sheet,
					 int dx1, int dy1, int dx2, int dy2, short col1, int row1, short col2, int row2) throws Exception {
	HSSFPatriarch hssfPatriarch = sheet.createDrawingPatriarch();
	URL url = new URL("");
	HttpURLConnection urlConnection = (HttpURLConnection) url.openConnection();
	urlConnection.setRequestMethod("GET");
	InputStream inputStream = urlConnection.getInputStream();
	byte[] byteData = readInputStream(inputStream);
	// 设置坐标
	HSSFClientAnchor anchor = new HSSFClientAnchor(dx1, dy1, dx2, dy2, col1, row1, col2, row2);
	// 设置图片
	hssfPatriarch.createPicture(anchor, workbook.addPicture(byteData, HSSFWorkbook.PICTURE_TYPE_JPEG));
}