poi.jar包学习笔记

最新推荐文章于 2022-06-17 11:53:34 发布

牧牛遛马

最新推荐文章于 2022-06-17 11:53:34 发布

阅读量350

点赞数

分类专栏：常用jar包学习笔记文章标签： poi java excel

本文链接：https://blog.csdn.net/qq_38205058/article/details/74936848

版权

常用jar包学习笔记专栏收录该内容

1 篇文章 0 订阅

订阅专栏

这里写图片描述

poi实现java编写excel文件和读取excel文件内容学习：

package com.sky.itext;

import java.io.FileInputStream;
import java.io.FileOutputStream;

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;

public class FirstExcel{

    public static String xlsFile = "E:/study/firstExcel.xls";

    public static void main(String[] args){
        //内容写入EXCEL中
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet();
        workbook.setSheetName(0, "firstSheet");
        HSSFRow rows = sheet.createRow(0);
        HSSFCell cell = rows.createCell(0);

        cell.setCellType(HSSFCell.CELL_TYPE_STRING);
        cell.setCellValue("牧牛遛马");
        try {
            FileOutputStream fos = new FileOutputStream(xlsFile);
            workbook.write(fos);
            fos.flush();
            fos.close();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } 

        //读取Excel文件内容

        try {
            FileInputStream fis = new FileInputStream(xlsFile);
            HSSFWorkbook readWorkbook = new HSSFWorkbook(fis);
            HSSFSheet readSheet = readWorkbook.getSheetAt(0);
            HSSFRow readRow = readSheet.getRow(0);
            HSSFCell readCell = readRow.getCell(0);
            System.out.println("第一个单元格的内容是"+readCell.getStringCellValue());

        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}