Excel 用Java读取

Excel 用Java读取

java读Excel

java 无框架读取Excel

先导入jar包
<dependency>
  <groupId>org.apache.poi</groupId>
  <artifactId>poi-ooxml</artifactId>
  <version>4.1.0</version>
</dependency>

App.java

package com.chenlin;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;

/**
 * Hello world!
 *
 */
public class App 
{
    public static void main( String[] args ) {
        try {
            FileInputStream fileInputStream = new FileInputStream("C:\\Users\\rimi\\Desktop\\test.xlsx");
            parseExcel(fileInputStream);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    //解析Excel
    private static void parseExcel(InputStream inputStream) throws IOException {
        //第一步，获取工作簿
        // 2007版excel之后用 XSSFWorkbook   之前用HSSFWorkbook
        Workbook sheets = new XSSFWorkbook(inputStream);
        //第二步，获取工作表
        Sheet sheet = sheets.getSheet("sheet1");
        //第三步，一行一行读取数据
        int firstRowNum = sheet.getFirstRowNum();
        int lastRowNum = sheet.getLastRowNum();
        for (int index = firstRowNum; index <=lastRowNum ; index++) {
            //根据行号，取出每一行
            Row row = sheet.getRow(index);

            //一列列的取出每个格子的值
            short firstCellNum = row.getFirstCellNum();
            short lastCellNum = row.getLastCellNum();
            for (int cellNum = firstCellNum; cellNum < lastCellNum; cellNum++) {
                //根据列号,获取每一个格子
                Cell cell = row.getCell(cellNum);
                cell.setCellType(CellType.STRING);
                String value = cell.getStringCellValue();
                System.out.print(value+" ");
            }
            System.out.println();
        }

    }
}
	

java 框架读取Excel

jar 包

    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>easyexcel</artifactId>
        <version>1.1.1</version>
    </dependency>