java 获取Excel内容

心已赠人 2023-07-24 08:34 23阅读 0赞

### 1.maven依赖 ###

<dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>3.17</version>
    </dependency>
    
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.15</version>
    </dependency>

### 2.工具类 ###

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
    import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
    import org.apache.poi.ss.usermodel.Cell;
    import org.apache.poi.ss.usermodel.Row;
    import org.apache.poi.ss.usermodel.Sheet;
    import org.apache.poi.ss.usermodel.Workbook;
    import org.apache.poi.xssf.usermodel.XSSFWorkbook;
    
    import java.io.File;
    import java.io.FileInputStream;
    import java.io.IOException;
    import java.io.InputStream;
    
    public class ExcelUtil { 
    
        public static void getExcelContext(String filePath) throws IOException, InvalidFormatException { 
            File file = new File(filePath);
            if(!file.exists()) { 
                System.out.println("文件不存在！");
                return;
            }
    
            Workbook workbook = null;
            String fileType = filePath.substring(filePath.lastIndexOf("."));
            if (".xls".equals(fileType)) { 
                InputStream stream = new FileInputStream(file);
                workbook = new HSSFWorkbook(stream);
            } else if (".xlsx".equals(fileType)) { 
                workbook = new XSSFWorkbook(file);
            }
    
            // 获取Excel中的sheet表
            Sheet sheet = workbook.getSheet("起运洲");
    // Sheet sheet = workbook.getSheetAt(0);
    
            int rows = sheet.getLastRowNum();
    
            for (int i = 0; i < rows; i++) { 
                // 获取当前行
                Row row = sheet.getRow(i);
                // 获取当前行列数
                int col = row.getLastCellNum();
                for (int j = 0; j < col; j++) { 
                    Cell cell = row.getCell(j);
                    System.out.print(cell.toString() + " ");
                }
                System.out.println();
            }
    
        }
    
    }