使用POI组件操作Excel文档

待我称王封你为后i 2022-09-30 06:52 186阅读 0赞

由于使用的是第三方组件所以需要引用jar包：  
![这里写图片描述][SouthEast]

实现文件的写入：

import java.io.FileOutputStream;
    import java.io.IOException;
    
    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 WriteExcel { 
    
        public static void main(String[] args) throws Exception {
            WriteExcel w = new WriteExcel();
    
            w.writeExcel("1.xlsx");
        }
        public void writeExcel(String filename)throws IOException{
    
            //创建一个新的Excel工作簿
            HSSFWorkbook workbook = new HSSFWorkbook();
    
            //在Excel表中新建一个工作表起名为java
            HSSFSheet sheet = workbook.createSheet("java");
    
            //创建第一行
            HSSFRow row = sheet.createRow(0);
    
            //创建第一列
            HSSFCell cell = row.createCell((short)0);
    
            //定义单元格为字符串类型
            cell.setCellType(HSSFCell.CELL_TYPE_STRING);
    
            //在单元格中输入内容
            cell.setCellValue("作者");
    
            //创建第二列
            cell = row.createCell((short)1);
    
            //定义单元格为字符串类型
            cell.setCellType(HSSFCell.CELL_TYPE_STRING);
    
            //在单元格中输入内容
            cell.setCellValue("编辑");
    
            //新建输出流
            FileOutputStream fos = new FileOutputStream(filename);
    
            //保存
            workbook.write(fos);
    
            //刷新
            fos.flush();
    
            //结束关闭
            fos.close();
        }
    
    
    }

实现文件的读出：

import java.io.FileInputStream;
    import java.io.FileNotFoundException;
    import java.io.IOException;
    
    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 ReadExcel {
    
    
        public static void main(String[] args) throws Exception {
            ReadExcel r = new ReadExcel();
    
            r.readExcel("1.xlsx");
        }
    
        public void readExcel(String fileName) throws FileNotFoundException, IOException{
    
            HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileName));
    
            //按照名字引用Excel表
            HSSFSheet sheet = workbook.getSheet("java");
            //也可以用以下方法获取Excel工作表，采用工作表的索引值
            //HSSFSheet sheet = workbook.getSheetAt(0);
    
            HSSFRow row = sheet.getRow(0);
    
            HSSFCell cell = row.getCell((short)0);
    
            //打印读取值
            System.out.println(cell.getStringCellValue());
    
            cell = row.getCell((short)1);
    
            System.out.println(cell.getStringCellValue());
        }
    }

实验结果：  
![这里写图片描述][SouthEast 1]

[SouthEast]: /images/20220708/68ac11daa65e411b958402ed1223f522.png
[SouthEast 1]: /images/20220708/ced04bd6c1fe42588b30cf1ba4c9a7f5.png