Java 怎样从 excel 中读取文件、写入文件

短命女 2023-10-02 09:03 42阅读 0赞

### 简介 ###

众多 Java 攻城狮对 excel 读写等使用并不精通。本文通过最易理解，拿来即用原则编写。

编写地址：https://javapub.blog.csdn.net/article/details/120166106

#### 文章目录 ####

*   *  简介
     *  一、读取Excel
     *   *  maven 依赖
         *  excel 文档格式
         *  java 源码
         *  运行结果
     *  二、写入Excel

### 一、读取Excel ###

#### maven 依赖 ####

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

> jar下载地址：https://download.csdn.net/download/qq\_40374604/22168010

#### excel 文档格式 ####

这里读取的是 `.xlsx` 格式文件  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBASmF2YVB1Yi1yb2RlcnQ_size_20_color_FFFFFF_t_70_g_se_x_16]

> 下载excel：https://download.csdn.net/download/qq\_40374604/22202363

#### java 源码 ####

package com.javapub;
    
    import org.apache.poi.xssf.usermodel.XSSFRow;
    import org.apache.poi.xssf.usermodel.XSSFSheet;
    import org.apache.poi.xssf.usermodel.XSSFWorkbook;
    
    import java.io.FileInputStream;
    
    public class ExcelTest {
        
        private static XSSFSheet sheet;
    
        public static void main(String[] args) {
        
            ExcelTest excelTest = new ExcelTest();
    
            String filePath = "D:\\java\\idea_workspace\\testAll\\src\\main\\resources\\excel\\testexcel.xlsx";//路径名
            String sheetName = "Sheet1";//表名
    
            FileInputStream fileInputStream = null;
            try {
        
                fileInputStream = new FileInputStream(filePath);
                XSSFWorkbook sheets = new XSSFWorkbook(fileInputStream);
                //获取sheet
                sheet = sheets.getSheet(sheetName);
                //获取第二行第4列
                String cell2 = excelTest.getExcelDateByIndex(1, 3);
                System.out.println(cell2);
                System.out.println("----------------------------------------------");
                excelTest.readExcelData();
            } catch (Exception e) {
        
                e.printStackTrace();
            } finally {
        
                if (fileInputStream != null) {
        
                    try {
        
                        fileInputStream.close();//关闭流
                    } catch (Exception e) {
        
                        e.printStackTrace();
                    }
                }
            }
        }
    
        /**
         * 根据行和列的索引获取单元格的数据
         *
         * @param row
         * @param column
         * @return
         */
        public String getExcelDateByIndex(int row, int column) {
        
            XSSFRow xssfRow = sheet.getRow(row);
            String cell = xssfRow.getCell(column).toString();
            return cell;
        }
    
        //打印excel数据
        public void readExcelData() {
        
            //获取行数
            int rows = sheet.getPhysicalNumberOfRows();
            for (int i = 0; i < rows; i++) {
        
                //获取列数
                XSSFRow row = sheet.getRow(i);
                int columns = row.getPhysicalNumberOfCells();
                for (int j = 0; j < columns; j++) {
        
                    String cell = row.getCell(j).toString();
                    System.out.println(cell);
                }
            }
        }
    
    }

#### 运行结果 ####

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBASmF2YVB1Yi1yb2RlcnQ_size_20_color_FFFFFF_t_70_g_se_x_16 1]

### 二、写入Excel ###

https://blog.csdn.net/galen2016/article/details/84840793

--------------------

> 无套路 Java源码及 Excel文件 获取交流![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBASmF2YVB1Yi1yb2RlcnQ_size_10_color_FFFFFF_t_70_g_se_x_16_pic_center]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBASmF2YVB1Yi1yb2RlcnQ_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/5234f210781646639901bb1f9dbb784b.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBASmF2YVB1Yi1yb2RlcnQ=,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBASmF2YVB1Yi1yb2RlcnQ_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/db09a2bed03444e6ad16941206e172c8.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBASmF2YVB1Yi1yb2RlcnQ=,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBASmF2YVB1Yi1yb2RlcnQ_size_10_color_FFFFFF_t_70_g_se_x_16_pic_center]: https://img-blog.csdnimg.cn/31307cb2b62943978fb341ebeca325bb.jpg?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBASmF2YVB1Yi1yb2RlcnQ=,size_10,color_FFFFFF,t_70,g_se,x_16#pic_center