java excel读取并存储_Java 读取Excel（xlsx）的内容及图片并保存

ゝ一世哀愁。 2022-11-11 10:59 305阅读 0赞

![955685fab6fd][]

所需jar

package com.example.testandroidx;

import org.apache.poi.openxml4j.opc.OPCPackage;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.CellType;

import org.apache.poi.ss.usermodel.PictureData;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.WorkbookFactory;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFClientAnchor;

import org.apache.poi.xssf.usermodel.XSSFPicture;

import org.apache.poi.xssf.usermodel.XSSFPictureData;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFShape;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.util.HashMap;

import java.util.Iterator;

import java.util.LinkedHashMap;

import java.util.List;

import java.util.Map;

public class TestReadFile \{

public final static String FILEPATH = "/Users/zal/Desktop/TextAndPicture.xlsx";

public static Map picMap = new HashMap<>();

public static void main(String\[\] args) \{

try \{

picMap = getPictureFromExcel(FILEPATH, 0);

for (String key : picMap.keySet()) \{

System.out.println(key + " ~~~ " + picMap.get(key).toString());

\} catch (Exception e) \{

e.printStackTrace();

System.out.println("\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*");

String text = readXlsx(FILEPATH);

System.out.println("\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*");

System.out.println(text);

/\*\*

\* 获取excel(xlsx)内容

\*/

public static String readXlsx(String path) \{

StringBuilder textBuilder = new StringBuilder();

try \{

OPCPackage pkg = OPCPackage.open(path);

XSSFWorkbook excel = new XSSFWorkbook(pkg);

//获取第一个sheet

String fileName = "", colValue = "";

int rowIndex = 0, colIndex = 0;

XSSFSheet sheet0 = excel.getSheetAt(0);

for (Row cells : sheet0) \{

XSSFRow row = (XSSFRow) cells;

colIndex = 0;

textBuilder.append(rowIndex).append("\\t");

for (Iterator iterator = row.cellIterator(); iterator.hasNext(); ) \{

XSSFCell cell = (XSSFCell) iterator.next();

//根据单元的的类型 读取相应的结果

if (cell.getCellType() == CellType.STRING) \{

colValue = cell.getStringCellValue();

\} else if (cell.getCellType() == CellType.NUMERIC) \{

colValue = cell.getNumericCellValue() + "";

\} else if (cell.getCellType() == CellType.FORMULA) \{

colValue = cell.getCellFormula();

\} else if (cell.getCellType() == CellType.FORMULA) \{

colValue = cell.getCellFormula();

textBuilder.append(colValue).append("\\t");

if (colIndex == 0) \{

fileName = colValue;

saveImg(rowIndex, colIndex, fileName);

colIndex++;

textBuilder.append("\\n");

rowIndex++;

\} catch (Exception e) \{

e.printStackTrace();

return textBuilder.toString();

/\*\*

\* 获取excel(xlsx)中的图片

\*/

public static Map getPictureFromExcel(String filePath, int sheetNum) throws Exception \{

FileInputStream fis = new FileInputStream(filePath);

//创建Map

Map map = new LinkedHashMap<>();

//获取HSSFWorkbook对象

XSSFWorkbook workbook = (XSSFWorkbook) WorkbookFactory.create(fis);

//获取当前表编码所对应的表

XSSFSheet sheet = (XSSFSheet) workbook.getSheetAt(sheetNum);

//获取图片列表

List list = sheet.getDrawingPatriarch().getShapes();

//对表格进行操作i

for (int i = 0; i < sheet.getDrawingPatriarch().getShapes().size(); i++) \{

XSSFShape shape = list.get(i);

XSSFClientAnchor anchor = (XSSFClientAnchor) shape.getAnchor();

if (shape instanceof XSSFPicture) \{

XSSFPicture pic = (XSSFPicture) shape;

//获取列编号

int col = anchor.getCol2();

XSSFPictureData picData = pic.getPictureData();

map.put(getImgKey(i, col), picData);

return map;

private static String getImgKey(int row, int col) \{

return row + ":" + col;

public static void saveImg(int row, int col, String name) \{

String filePath = "/Users/zal/Desktop/xlsxImg/" + name + ".jpeg";

saveImg(picMap, getImgKey(row, col), filePath);

public static void saveImg(Map map, String key, String filePath) \{

PictureData picData = map.get(key);

if (picData == null) \{

//System.out.println(key + " 无图 " + filePath);

return;

System.out.println(key + " 有图 " + filePath);

byte\[\] data = picData.getData();

FileOutputStream out = null;

try \{

out = new FileOutputStream(filePath);

out.write(data);

\} catch (IOException e) \{

e.printStackTrace();

\} finally \{

try \{

if (out != null) \{

out.close();

\} catch (IOException e) \{

e.printStackTrace();

[955685fab6fd]: /images/20221022/8c110832391941dbafe853a5ed3a8a9e.png

java excel读取并存储_Java 读取Excel（xlsx）的内容及图片并保存

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Java读取Excel并生成Word&PDF

相关 Java 执行命令并读取缓冲区内容

相关 java+pgsql实现保存图片到数据库，以及读取数据库存储的图片；java将图片保存到本地、保存到数据库、java将图片保存到本地并保存到数据库、java从数据库postgresql读取图片

相关 java excel读取并存储_Java 读取Excel（xlsx）的内容及图片并保存

相关 java 读取并保存excel中的图片

相关【Java】Java从网络读取图片并保存至本地

相关 opencv中批量读取图片并保存

相关 java 读取图片并存储到数据库中

相关 Java读取在线文件并保存至本地

相关上传读取Excel文件内容并入库