JAVA POI 图片插入excel保存导出,可多图,多种插入样式

JAVA POI 图片插入excel保存导出,可多图,多种插入样式

JAVA POI 图片插入excel保存导出,可多图,多种插入样式

import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.util.Date;

import javax.imageio.ImageIO;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExcelByImg {
   

	public static void main(String[] args) {
   
		// 1.竖向排列
		exportExcelOne();
		// 2.横向排列
		exportExcelTwo();
		// 3. 同一个单元格横向排列
		exportExcelThree();
		// 4.同一个单元格竖向排列
		exportExcelFour();
	}

	/**
	 * 1.竖向排列
	 */
	public static void exportExcelOne() {
   
		String[] imgs = {
    "D:\\888.jpg", "D:\\666.jpg", "D:\\777.jpg" };
		HSSFWorkbook workBook = new HSSFWorkbook();// 创建工作簿
		HSSFSheet sheet = workBook.createSheet();// 创建工作表
		sheet.setColumnWidth(0, 4800);// 列宽
		BufferedImage bufferedImage = null;
		HSSFPatriarch hSSFPatriarch = sheet.createDrawingPatriarch();// 画图管理器
		try {
   
			for (int i = 0; i < imgs.length; i++) {
   
				HSSFRow imgRow = sheet.createRow(i);// 行
				File file