對于需要納入網(wǎng)盤管理的文件相當(dāng)多徐裸，而且相當(dāng)多，怎么辦滨溉，本人使用Java寫了一個工具，
只要設(shè)置一個文件目錄后长赞，自動導(dǎo)出文件目錄清單（excel格式）晦攒，
具體代碼如下：

package pan;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;

import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class RocFileExcelMain {
private static final String TARGET_DIR="E:\BaiduNetdiskDownload\xxx";

private static final String LINE_SEPARATOR = System.getProperty("line.separator");

public static void main(String[] args) {
    RocFileExcelMain main=new RocFileExcelMain();
    main.doMainExcel();
}

//current row
private int currentRow=0;
private int currentCol=0;
public void doMainExcel(){
    File dir = new File(TARGET_DIR); // 被遍歷的目錄。//E:\\Java_Code
    String path4dir=dir.getPath();
    String fileName4dir = path4dir.substring(path4dir.lastIndexOf("\\")+1);
    File newFile = createNewFile(fileName4dir);
    
    // 新文件寫入數(shù)據(jù)得哆，并下載*****************************************************
    InputStream is = null;
    XSSFWorkbook workbook = null;
    XSSFSheet sheet = null;
    try {
        is = new FileInputStream(newFile);// 將excel文件轉(zhuǎn)為輸入流
        workbook = new XSSFWorkbook(is);// 創(chuàng)建個workbook脯颜，
        //獲取第一個sheet
        sheet = workbook.getSheetAt(0);
    } catch (Exception e1) {
        e1.printStackTrace();
    }

    if (sheet != null) {
        try {
            // 寫數(shù)據(jù)
            FileOutputStream fos = new FileOutputStream(newFile);
            //空三行
            XSSFRow row = sheet.getRow(3);
            if (row == null) {
                row = sheet.createRow(3);
            }
            XSSFCell cell = row.getCell(0);
            if (cell == null) {
                cell = row.createCell(0);
            }
            
            XSSFCellStyle cellStyle=workbook.createCellStyle();       
            cellStyle.setWrapText(true);                
            print(sheet,cellStyle,dir,0);
            
            /* 定義一個list集合假數(shù)據(jù)
            List<Map<String, Object>> lst = new ArrayList();
            Map<String, Object> map1 = new HashMap<String, Object>();
            for (int i = 0; i < 42; i++) {
                map1.put("id" + i, i);
                lst.add(map1);
            }
            
            */
            
            
            
            //最后寫入文件中
            workbook.write(fos);
            fos.flush();
            fos.close();
            
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (null != is) {
                    is.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
    // 刪除創(chuàng)建的新文件
    // this.deleteFile(newFile);
    }

/*
for (int m = 0; m < lst.size(); m++) {
                Map<String, Object> map = lst.get(m);
                row = sheet.createRow((int) m + 3);
                for (int i = 0; i < 42; i++) {
                    String value = map.get("id" + m) + "";
                    if (value.equals("null")) {
                        value = "0";
                    }
                    cell = row.createCell(i);
                    cell.setCellValue(value);
                }
            }
 */
public void print(XSSFSheet sheet,XSSFCellStyle cellStyle,File f, int level) {
    StringBuffer sf=new StringBuffer();
    for (int i = 0; i < level; i++) {
        //System.out.print(" ");
        sf.append(" ");
    }
    //System.out.println(f.getName());
    currentRow++;
    XSSFRow row = sheet.createRow((int) currentRow + 3);
    if (f.isDirectory()) {//目錄
        XSSFCell cell = row.createCell(0);cell.setCellValue("目錄");
        String path=f.getPath();
        String fileName = path.substring(path.lastIndexOf("\\")+1);
        currentCol++;
        if(level>0){
            XSSFCell cellN = row.createCell(level);cellN.setCellStyle(cellStyle); cellN.setCellValue(fileName);
            //sf.append(level).append("級目錄：").append(f.getName()).append(LINE_SEPARATOR);
        }else{//設(shè)置標題
            sheet.getRow(0).getCell(0).setCellValue("文件清單【"+fileName+"】");
        }
        //
        
        //迭代后續(xù)
        for (File subF : f.listFiles()) {
            print(sheet,cellStyle,subF, level + 1);
        }
    }else{//文件
        XSSFCell cell = row.createCell(0);cell.setCellValue("文件");
        //sf.append(level).append("級文件：").append(f.getName()).append(LINE_SEPARATOR);
        XSSFCell cellN = row.createCell(level);cellN.setCellStyle(cellStyle);cellN.setCellValue(f.getName());
    }
    
        
}


/**
 * 復(fù)制文件
 * 
 * @param s
 *            源文件
 * @param t
 *            復(fù)制到的新文件
 */
public void fileChannelCopy(File s, File t) {
    try {
        InputStream in = null;
        OutputStream out = null;
        try {
            in = new BufferedInputStream(new FileInputStream(s), 1024);
            out = new BufferedOutputStream(new FileOutputStream(t), 1024);
            byte[] buffer = new byte[1024];
            int len;
            while ((len = in.read(buffer)) != -1) {
                out.write(buffer, 0, len);
            }
        } finally {
            if (null != in) {
                in.close();
            }
            if (null != out) {
                out.close();
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}

/**
 * two parent level directory to find sisp
 * /D:/java/eclipse_4.3/workspace/rocpan/bin/
 * D:/java/eclipse_4.3/workspace/rocpan/
 * @return
 */
private String getSispPath() {
    String classPaths = RocFileExcelMain.class.getResource("/").getPath();
    String[] aa = classPaths.split("/");
    String sispPath = "";
    for (int i = 1; i < aa.length - 1; i++) {
        sispPath += aa[i] + "/";
    }
    return sispPath;
}



/**
 * 讀取excel模板，并復(fù)制到新文件中供寫入和下載
 * 
 * @return
 */
public File createNewFile(String fileName4dir) {
    // 讀取模板贩据，并賦值到新文件************************************************************
    // 文件模板路徑
    String temp4path = (getSispPath() + "templateExcel/temp_pan.xlsx");
    File temp4file = new File(temp4path);
    // 保存文件的路徑
    String targetDir = TARGET_DIR;
    File dir = new File(targetDir);
    String dir4parent=dir.getParentFile().getPath();
    // 判斷路徑是否存在
    if (!dir.exists()) {
        dir.mkdirs();
    }
    
    // 新的文件名
    String newFileName = fileName4dir+"_文件清單.xlsx";
    // 寫入到新的excel
    File newFile = new File(dir4parent, newFileName);
    try {
        newFile.createNewFile();
        // 復(fù)制模板到新文件
        fileChannelCopy(temp4file, newFile);
    } catch (Exception e) {
        e.printStackTrace();
    }
    return newFile;
}
/**
 * 下載成功后刪除
 * 
 * @param files
 */
private void deleteFile(File... files) {
    for (File file : files) {
        if (file.exists()) {
            file.delete();
        }
    }
}

}