Skip to content

Instantly share code, notes, and snippets.

View partoneplay's full-sized avatar
🎯
Focusing

佐博 partoneplay

🎯
Focusing
View GitHub Profile
#!/bin/bash
### 在这里填写帮助信息
### my-script — does one thing well
###
### Usage:
### my-script <input> <output>
###
### Options:
### <input> Input file to read.
### <output> Output file to write. Use '-' for stdout.
@partoneplay
partoneplay / ExcelUtils.java
Created July 11, 2022 06:05
Read Excel rows as POJO List(Using Apache POI and Jackson)
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.node.ObjectNode;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.WorkbookUtil;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;