java读取excel文件并复制(copy)文件到指定目录示例

针对“java读取excel文件并复制(copy)文件到指定目录示例”，我为您提供以下攻略：

一、读取Excel文件

读取Excel文件需要用到Java中的POI工具包，具体的操作步骤如下：

1. 添加依赖包

在Maven的pom.xml文件中添加如下的依赖：

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

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

1. 创建工作簿和工作表对象

String filePath = "src/main/resources/excel/test.xlsx";
FileInputStream fileInputStream = new FileInputStream(filePath);
Workbook workbook = new XSSFWorkbook(fileInputStream);
Sheet sheet = workbook.getSheetAt(0);

1. 遍历Excel文件中的数据

Iterator<Row> rowIterator = sheet.rowIterator();
while (rowIterator.hasNext()){
    Row row = rowIterator.next();
    Iterator<Cell> cellIterator = row.cellIterator();
    while (cellIterator.hasNext()){
        Cell cell = cellIterator.next();
        String cellData = cell.getStringCellValue();
        System.out.println(cellData);
    }
}

二、复制文件到指定目录

复制文件到指定目录需要用到Java中的IO流，具体的操作步骤如下：

1. 使用FileInputStream和FileOutputStream分别读取源文件和写入目标文件

FileInputStream inStream = new FileInputStream("src/main/resources/img/source.png");
FileOutputStream outStream = new FileOutputStream("src/main/resources/img/target.png");

1. 创建byte数组存储读取到的数据并写入目标文件

byte[] buffer = new byte[1024];
int length;
while ((length = inStream.read(buffer)) > 0){
    outStream.write(buffer, 0, length);
}

1. 关闭IO流

inStream.close();
outStream.close();

接下来，我们可以将读取Excel文件和复制文件到指定目录的步骤结合起来，实现一个完整的示例代码：

public static void main(String[] args) throws IOException {
    String filePath = "src/main/resources/excel/test.xlsx";
    String sourceImgPath = "src/main/resources/img/source.png";
    String targetImgPath = "src/main/resources/img/target.png";
    FileInputStream fileInputStream = new FileInputStream(filePath);
    Workbook workbook = new XSSFWorkbook(fileInputStream);
    Sheet sheet = workbook.getSheetAt(0);

    // 读取Excel文件
    Iterator<Row> rowIterator = sheet.rowIterator();
    while (rowIterator.hasNext()){
        Row row = rowIterator.next();
        Iterator<Cell> cellIterator = row.cellIterator();
        while (cellIterator.hasNext()){
            Cell cell = cellIterator.next();
            String cellData = cell.getStringCellValue();
            System.out.println(cellData);
        }
    }

    // 复制文件到指定目录
    FileInputStream inStream = new FileInputStream(sourceImgPath);
    FileOutputStream outStream = new FileOutputStream(targetImgPath);
    byte[] buffer = new byte[1024];
    int length;
    while ((length = inStream.read(buffer)) > 0){
        outStream.write(buffer, 0, length);
    }
    inStream.close();
    outStream.close();

    // 关闭流对象
    fileInputStream.close();
    workbook.close();
}

另外，还有另一种示例，可以通过使用Apache Commons IO库中提供的FileUtils类来实现复制文件的功能，代码如下：

String sourcePath = "src/main/resources/img/source.png";
String targetPath = "src/main/resources/img/target.png";
File source = new File(sourcePath);
File target = new File(targetPath);
FileUtils.copyFile(source, target);

该方法使用起来更加简便，但是对于大文件的处理速度可能会较慢。因此，需要根据具体的需求，选择合适的方法。