使用poi从excel文件中读取图像和数据 [英] reading images and data from excel file using poi

问题描述

我知道如何从excel xls/xlxs中读取数据.现在我的要求是我必须使用POI 3.8从excel文件读取图像和数据.你能指导我怎么做吗? 使用poi从一个excel文件中读取图像和数据....预先感谢

i know how to read data from excel xls/xlxs. now my requirement is that i have to read image and data from excel file using POI 3.8. can you please guide me how to do that. reading images and data both from one excel file using poi.... Thanks in advance

推荐答案

直接来自开发人员指南:

List lst = workbook.getAllPictures();
for (Iterator it = lst.iterator(); it.hasNext(); ) {
    PictureData pict = (PictureData)it.next();
    String ext = pict.suggestFileExtension();
    byte[] data = pict.getData();
    if (ext.equals("jpeg")){
      FileOutputStream out = new FileOutputStream("pict.jpg");
      out.write(data);
      out.close();
    }
}

RTM:)

这篇关于使用poi从excel文件中读取图像和数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！