maven依賴

<dependency><groupId>com.alibaba</groupId><artifactId>fastjson</artifactId><version>1.2.28</version> </dependency> <dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>2.2.7</version><scope>compile</scope> </dependency>

Java工具類

import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook;import java.io.File; import java.io.IOException; import java.util.LinkedHashMap; import java.util.Set;/*** @author: wangzhongxing* @date: 2021/12/20 14:01* @description: JSON數據轉Excel工具類*/ public class ExcelUtil {/*** JSONArray轉Excel表格* 表格的數據列數取自于JSONArray第一個對象的所有key值，所JSONArray的第一行數據必須是全的，否則會導致部分數據列顯示不出來* @param jsonArray* @param excelFilePath*/public static void jsonToExcel(JSONArray jsonArray, String excelFilePath) {try{//此處為你的json數組HSSFWorkbook sheets = jsonToExcel(jsonArray);// 文件下載File excelFile = new File(excelFilePath);sheets.write(excelFile);sheets.close();} catch (Exception e) {}}/*** json 轉 excel* @param jsonArray* @return* @throws IOException*/private static HSSFWorkbook jsonToExcel(JSONArray jsonArray) {Set<String> keys = null;// 創建HSSFWorkbook對象HSSFWorkbook wb = new HSSFWorkbook();// 創建HSSFSheet對象HSSFSheet sheet = wb.createSheet("sheet0");int roleNo = 0;int rowNo = 0;// 創建HSSFRow對象HSSFRow row = sheet.createRow(roleNo++);// 創建HSSFCell對象// 創建表格標題keys = jsonArray.getJSONObject(0).keySet();for (String s : keys) {HSSFCell cell = row.createCell(rowNo++);cell.setCellValue(s);}rowNo = 0;for (int i = 0; i < jsonArray.size(); i ++) {JSONObject jsonObject = jsonArray.getJSONObject(i);row = sheet.createRow(roleNo++);for (String s : keys) {HSSFCell cell = row.createCell(rowNo++);cell.setCellValue(jsonObject.getString(s));}rowNo = 0;}return wb;}public static void main(String[] args) {JSONArray jsonArray = new JSONArray();JSONObject o1 = new JSONObject();o1.put("screenWidth", 1280);o1.put("screenHight", 2270);o1.put("trackState", 1);jsonArray.add(o1);JSONObject o2 = new JSONObject(new LinkedHashMap<>());o2.put("screenWidth", 1270);o2.put("trackState", 2);jsonArray.add(o2);JSONObject o3 = new JSONObject(new LinkedHashMap<>());o3.put("screenHight", 1290);o3.put("trackState", 3);jsonArray.add(o3);jsonToExcel(jsonArray, "D:\\temp\\word\\export.xls");}}

總結

以上是生活随笔為你收集整理的Java JSON转Excel工具类的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。