java poi 导入导出多个sheet 的excel数据

首先要使用java poi要导入相应的jar。

导入：

pulic class excelUtil{

   

/**
     * 数据导入到excel
     */
     public static void importData(filePath){
        HSSFWorkbook workbook=new HSSFWorkbook(new FileInputStream(new File(filePath)));
        HSSFSheet sheet=null;
//        List<String> sheetNameList = new ArrayList<>();
        List<List<List<String>>> listData = new ArrayList<>();
        for (int i = 0; i < workbook.getNumberOfSheets(); i++) {//获取每个Sheet表
//            sheetNameList.add(workbook.getSheetName(i));
             sheet=workbook.getSheetAt(i);
             List<List<String>> sheetList = new ArrayList<>();
             for (int j = 0; j < sheet.getPhysicalNumberOfRows(); j++) {//获取每行
                HSSFRow row=sheet.getRow(j);