Excel 读取，POI

最新推荐文章于 2023-03-28 15:55:58 发布

关云chnag

最新推荐文章于 2023-03-28 15:55:58 发布

阅读量110

点赞数

分类专栏： Java之路文章标签： poi java

本文链接：https://blog.csdn.net/zhoufeiy/article/details/106833468

版权

Java之路专栏收录该内容

7 篇文章 0 订阅

订阅专栏

读取excel数据

package com.zy.poi;

import org.apache.poi.hssf.usermodel.*;


import java.io.FileInputStream;

public class Test03 {
    //读取
    public static void main(String[] args) throws Exception {
        //获取流
        FileInputStream fileInputStream = new FileInputStream("C:\\Users\\Administrator\\Desktop\\aaa111.xls");
        //流转为hssfwork 对象
        HSSFWorkbook hssfWorkbook = new HSSFWorkbook(fileInputStream);
        HSSFSheet sheet1 = hssfWorkbook.getSheet("sheet1");
        HSSFRow row = sheet1.getRow(2);
        HSSFCell cell = row.getCell(3);
        String stringCellValue = cell.getStringCellValue();
        System.out.println(stringCellValue);

    }

}

写数据到Excel

package com.zy.poi;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import java.io.FileOutputStream;

public class Test02 {
    public static void main(String[] args) throws Exception {
        HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
        //创建表sheet01
        HSSFSheet sheet01 = hssfWorkbook.createSheet("sheet01");
        //创建行row
        HSSFRow row = sheet01.createRow(1);
        //创建列对应的cell
        HSSFCell cell = row.createCell(2);
        //为cell添加内容
        cell.setCellValue("天下兴亡，匹夫有责");
        FileOutputStream fileOutputStream = new FileOutputStream("C:\\Users\\Administrator\\Desktop\\aaa111.xls");
        hssfWorkbook.write(fileOutputStream);
        System.out.println("成功");
        fileOutputStream.close();
    }
}