poi本地生成Excel到桌面

最新推荐文章于 2023-02-28 15:18:01 发布

阿尘

最新推荐文章于 2023-02-28 15:18:01 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

分类专栏： JAVA 文章标签： excel null url import string io

本文链接：https://blog.youkuaiyun.com/wudianlong2008/article/details/6759438

JAVA 专栏收录该内容

10 篇文章

订阅专栏

这个Java程序演示了如何使用Apache POI库创建一个Excel文件，并将从URL下载的图片插入到工作表中。最终文件被保存到用户的桌面。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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();
    }
   }
}
}
}