package Test;
import cn.hutool.core.io.IoUtil;
import cn.hutool.poi.excel.BigExcelWriter;
import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import com.alibaba.fastjson.JSONObject;
import lombok.AllArgsConstructor;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.util.*;
@AllArgsConstructor
public class ExcelTest
{
static Map> st = new HashMap<>();
static Map> ss = new HashMap<>();
static int size=0;
public static void main(String[] args) throws FileNotFoundException{
/* List> read =
new ArrayList<>();
for (int i = 0; i < 4; i++) {
ExcelReader reader = ExcelUtil.getReader("F://545分表.xlsx",i);
read.addAll( reader.read(0));
}*/
ExcelReader reader = ExcelUtil.getReader("F://444分表.xlsx",0);
List> read = reader.read(0);
print(read.get(0));
//明细文件
ExcelReader reader1 = ExcelUtil.getReader("F://收支明细20220506115416_RYBQDT.xlsx");
List> read1 = reader1.read(0);
print(read1.get(0));
for (int i = 0; i < read.size(); i++) {
eq(read.get(i),read1);
}
w(ss.values());
System.out.println(""+size);
System.out.println(""+ss.values().size());
}
private static void eq(List