package com.example.demo.util;
import com.fasterxml.jackson.databind.node.ArrayNode;
import com.fasterxml.jackson.databind.node.ObjectNode;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.util.List;
public class Xlsx2Json {
/**
* 把xlsx文件转换为Json数据
* 使用了先前定义的json工具类 :https://blog.csdn.net/weixin_39189376/article/details/100203480
* @param JsonResultList
* @return
*/
public static List<ObjectNode> XlsxToJson(List<ObjectNode> JsonResultList) {
try {
XSSFWorkbook book = new XSSFWorkbook(file.getInputStream());
XSSFSheet sheet = book.getSheetAt(0);
ObjectNode nodeCommon1 = JsonUtil.createObject();
nodeCommon1.put("val", "");
nodeCommon1.put("other", 0);
for
excel数据转json并存储在list中
最新推荐文章于 2023-01-19 17:06:36 发布