Excel文件编程

引入依赖

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

写个小示例

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.*;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;

/**
 * @ClassName test
 * @Author 
 * @Date 2020/12/15 13:39
 * @Version 1.0
 **/
public class test {
    public static void main(String[] args) {
        File file=new File("D:\\test02.xls");
        try {
            file.createNewFile();
        } catch (IOException e) {
            e.printStackTrace();
        }
        String name = file.getName();
        String path=file.getAbsolutePath();
        String path1 = file.getPath();
        test2(path);
        test3(path);
    }
    public static void test2(String name){
        //创建工作簿
        Workbook wb=new HSSFWorkbook();
        Sheet sheet=wb.createSheet("testSheet");
        Row row =sheet.createRow(0);
        row.createCell(0).setCellValue(1);
        row.createCell(1).setCellValue(2);
        row.createCell(2).setCellValue(3);
        row.createCell(4).setCellValue("name");
        try {
            OutputStream fileOut=new FileOutputStream(name);
            wb.write(fileOut);
            wb.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    public static void test3(String name) {
        try {
            POIFSFileSystem fs = new POIFSFileSystem(new File(name));
            HSSFWorkbook wb = new HSSFWorkbook(fs.getRoot(),true);
            Sheet sheet=wb.getSheetAt(0);
            if(sheet != null){
                int rowNos = sheet.getLastRowNum();// 得到excel的总记录条数
                for (int i = 0; i <= rowNos; i++) {// 遍历行
                    Row row = sheet.getRow(i);
                    if(row != null){
                        int columNos = row.getLastCellNum();// 表头总共的列数
                        for (int j = 0; j < columNos; j++) {
                            Cell cell = row.getCell(j);
                            if(cell != null){
                                cell.setCellType(CellType.STRING);
                                System.out.println(cell.getStringCellValue());
                            }
                        }
                    }
                }
            }
            fs.close();
        }catch (Exception e){e.printStackTrace();}
    }
}

如果是在c盘操纵文件的话，会报“拒绝访问”，主要是因为没有权限，建议在别的盘里试一下