java 读取 excel 图片_java读取excel图片

package com.milanoo.wms;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.text.ParseException;

import com.milanoo.wms.utils.ExcelUtils;

import jxl.Image;

import jxl.Sheet;

import jxl.Workbook;

public class TestExcelImg {

public static void main(String[] args) throws ParseException {

saveSheetImgByFile("D://temp",new File("D://nileoo_product_template.xls"));

}

public static void saveSheetImgByFile(String basePath,File is) throws ParseException {

FileOutputStream os = null;

try {

Workbook wbk = Workbook.getWorkbook(is);

//建文件目录

File mkFile = new File(basePath);

if (!mkFile.exists() && !mkFile.isDirectory()) {

mkFile.mkdirs();

}

// 循环所有sheet

for (int k = 0; k < wbk.getNumberOfSheets(); k++) {

Sheet sheet = wbk.getSheet(k);

// 共有多少行

int imgNumber = sheet.getNumberOfImages();// 获得sheet所包含的图片数

// 循环sheet的所有图片

for (int i = 0; i < imgNumber; i++) {

Image image = sheet.getDrawing(i);

byte[] imageData = image.getImageData();

String fileName = image.getImageFile().getName().trim()

+ ".jpg";

File file = new File(basePath+"/" + fileName);

os = new FileOutputStream(file);// 建立一个上传文件的输出流

os.write(imageData, 0, imageData.length);// 将文件写入服务器

}

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

} finally {

try {

if (os != null) {

os.close();

}

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

}