poi本地生成Excel到桌面

来源：互联网发布：逆战淘宝代练那家好编辑：程序博客网时间：2024/06/15 23:54

package com;

import java.io.FileOutputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.net.URL;
import java.awt.image.BufferedImage;
import javax.imageio.*;
import javax.swing.filechooser.FileSystemView;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
public class PicExcel {
public static void main(String[] args) {
FileOutputStream fileOut = null;
BufferedImage bufferImg = null;
try {
   URL url = new URL(
     "http://hiphotos.baidu.com/youyu0503/pic/item/3f1e42a7dbc6dfc89152ee19.jpg");
   ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
   bufferImg = ImageIO.read(url.openStream());
   ImageIO.write(bufferImg, "jpg", byteArrayOut);
   // 创建一个工作薄
   HSSFWorkbook wb = new HSSFWorkbook();
   HSSFSheet sheet1 = wb.createSheet("new sheet");
   HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();
   HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 512, 255,
     (short) 0,0, (short) 10, 20);
   // 插入图片
   patriarch.createPicture(anchor, wb.addPicture(byteArrayOut
     .toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
   FileSystemView fsv = FileSystemView.getFileSystemView();//获取本的桌面路径
   fileOut = new FileOutputStream(fsv.getHomeDirectory().toString()+"word.xls");
   // 写入excel文件
   wb.write(fileOut);
   fileOut.close();
} catch (IOException io) {
   io.printStackTrace();
   System.out.println("io erorr : " + io.getMessage());
} finally {
   if (fileOut != null) {
    try {
     fileOut.close();
    } catch (IOException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
    }
   }
}
}
}