package ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
import .*;
/**
* Description :
*
* @author : HMF
* Date : Created in 10:40 2023/11/23
* @version :
*/
public class ExcelUtil {
/**
* 读取excel,放入List<Map<String, String>>
* @param filePath 读取excel的文件路径+文件名称
* @return datalist
*/
public static List<Map<String,Object>> readExcel(String filePath){
return readExcel(filePath,null);
}
/**
* 读取excel,放入List<Map<String, String>>
* @param filePath 读取excel的文件路径+文件名称
* @Param sheetName sheet名称
* @return datalist
*/
public static List<Map<String,Object>> readExcel(String filePath,String sheetName){
List<Map<String,Object>> resultList = new ArrayList<>();
Map<Integer, String> headMap = new HashMap<>();
try {
File file = new File(filePath);
FileInputStream fis = new FileInputStream(file);
XSSFWorkbook wb = new XSSFWorkbook(fis);
//获取sheet第一个
XSSFSheet xSheet = (0);
if(sheetName!=null) {
//如果sheetName入参可用这个,通过名称获取
xSheet = (sheetName);
}
for (int i = 0; i <= (); i++) { //遍历所有行
if(i==0){ //标题行
for (int j = 0; j < (i).getPhysicalNumberOfCells(); j++) {
(j, (i).getCell(j).toString());
}
continue;
}
Map<String, Object> paramsMap = new HashMap<>();
for (int j = 0; j < (i).getPhysicalNumberOfCells(); j++) { //遍历当前行所有列
String key=(j);
Cell cell=(i).getCell(j);
switch (()) {
case Cell.CELL_TYPE_STRING:
(key,());
break;
case Cell.CELL_TYPE_NUMERIC:
(key,new Double(()).intValue());
break;
}
//(key,(i).getCell(j));
}
(paramsMap);
}
}catch (IOException e){
(e);
}
return resultList;
}
/**
* 写入excel
* @param filePath 读取excel的文件路径+文件名称
* @Param sheetName sheet名称
* @param listA 入参列表
* @param listHead 标题头列表
*/
public static void writeExcel(String filePath, String sheetName, List<Map<String, Object>> listA,List<String> listHead){
XSSFWorkbook xwb = new XSSFWorkbook();
XSSFSheet sheet = (sheetName);
//标题行
XSSFRow row = (0);
for (int i=0;i<();i++){
//根据需要给第一行每一列设置标题
XSSFCell cell = (i);
((i));
}
//创建行
XSSFRow rows;
//创建列，即单元格Cell
XSSFCell cells;
//把List里面的数据写到excel中(除标题行外)
for (int i=0;i<();i++) {
//从第一行开始写入
rows = (i + 1);
//创建每个单元格Cell，即列的数据
Map<String, Object> testMap =(i);
for (int j=0;j<();j++){
cells = (j);
String head=(j);
String type=(head).getClass().getTypeName();
switch (type) {
case "":
((int) (head));
break;
case "":
((String) (head));
break;
}
}
}
//用输出流写到excel
try {
File file = new File(filePath);
FileOutputStream outputStream = new FileOutputStream(file);
(outputStream);
();
();
}catch (IOException e) {
();
}
}
public static void main(String args[]){
String filePath="src/main/resources/";
List<Map<String, Object>> resultList= readExcel(filePath,"Sheet1");
for(Map<String, Object> testMap:resultList){
(testMap);
// for(String excKey :()){
// (excKey+": "+(excKey));
// }
}
List<String> listHead =new ArrayList<>();
("id");
("name");
("age");
("grade");
writeExcel("src/main/resources/","result",resultList,listHead);
}
}