java 读取并保存excel中的图片

客官°小女子只卖身不卖艺 2022-08-27 13:41 368阅读 0赞

/\*  
\* 保存excel中的图片(以文件形式保存，或者存入数据库)  
\*  
\* basePath:应用所在路径,附件存放路径:  
\* 参数：is是上传的附件文件流  
\*/  
public void saveSheetImgByFile(String basePath,InputStream 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();  
\}  
\}  
\}  
  
/\*  
\* 将excel图片文件保存到数据库  
\*/  
public void saveSheetImgByDB(InputStream is) throws ParseException,  
ClassNotFoundException, SQLException, IOException \{  
Class.forName("com.mysql.jdbc.Driver");  
Connection conn = DriverManager.getConnection(  
"jdbc:mysql://localhost:3306/数据库名?characterEncoding=utf8", "root", "root");  
String INSERT\_PICTURE = "insert into t\_mypicture(name, photo) values (?, ?)";  
PreparedStatement ps = null;  
FileOutputStream os = null;  
try \{  
Workbook wbk = Workbook.getWorkbook(is);  
// 循环所有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";  
  
conn.setAutoCommit(false);  
ps = conn.prepareStatement(INSERT\_PICTURE);  
ps.setString(1, fileName);  
ps.setBytes(2, imageData);  
ps.executeUpdate();  
conn.commit();  
\}  
\}  
\} 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();  
\}  
\}  
\}

2.action方法调用:

ImportExcelUtil ieu = new ImportExcelUtil();  
ExcelForm excelForm = (ExcelForm) form;  
FormFile file = excelForm.getExcelFile();  
  
  
// 附件方式保存  
String basePath = request.getSession().getServletContext().getRealPath(  
"/")+"excelFile";  
try \{  
ieu.saveSheetImgByFile(basePath,file.getInputStream());  
\} catch (Exception e) \{  
// TODO Auto-generated catch block  
e.printStackTrace();  
\}

// 数据库方式保存  
try \{  
ieu.saveSheetImgByDB(file.getInputStream());  
\} catch (Exception e) \{  
// TODO Auto-generated catch block  
e.printStackTrace();  
\}