解析 .xls 后缀的文件,最终组装成 List<Map<String, String>> 形式的结果。包含读取excel 和写入excel
代码如下
```java
import com.alibaba.fastjson.JSON;
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 org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Component;
import java.io.*;
import java.util.*;
@Component
public class ExcelService {
private static final Logger LOGGER = LoggerFactory.getLogger(ExcelService.class);
/**
* 读取 excel 文件
* @param is 输入流
*/
public JSONObject readExcel(InputStream is) {
try {
LOGGER.info("开始解析 Excel 文件!");
HSSFWorkbook workbook = new HSSFWork