我想将displayDirectoryContents的输出写入Excel工作表

2024-05-20 • 问答

我尝试使用Apache POI方法将输出输出到Excel工作表一列中的文件夹和文件名另一列中文件的名称导入语句

public class Excel {

private static String dest = "C:\\Users\\mahselva\\testexcel.xls";
private static HSSFWorkbook myWorkBook = new HSSFWorkbook();
private static HSSFSheet mySheet = myWorkBook.createSheet();

public static void excelLog(String filename,String message,int rowNum) 
{

HSSFRow myRow = null;
HSSFCell myCell = null;
String excelData[][] = new String[1][2];
excelData[0][0] = filename;
excelData[0][1] = message;

myRow = mySheet.createRow(rowNum);

for (int cellNum = 0; cellNum < 2; cellNum++) {
    myCell = myRow.createCell(cellNum);
    myCell.setCellValue(excelData[0][cellNum]);

}
try {
    FileOutputStream out = new FileOutputStream(dest);
    myWorkBook.write(out);
    out.close();
} catch (Exception e) {
    e.printStackTrace();
}
}

public static void main(String[] args) {
File currentDir = new File("C:\\OracleATS\\openScript"); // current 
directory
displayDirectoryContents(currentDir);
}
public static void displayDirectoryContents(File dir) {
try {
    int i = 0;
    File[] files = dir.listFiles();
    for (File file : files) {
        if (file.isDirectory()) {
            Path path = Paths.get(file.getcanonicalPath());
            //System.out.println("Folder" 
+path.getFileName().toString());
            excelLog("Folder",path.getFileName().toString(),i);
            i++;
            displayDirectoryContents(file);
        } else {
            Path path = Paths.get(file.getcanonicalPath());
            //System.out.println(path.getFileName().toString());
            excelLog("File",i);
            i++;
        }

    }
} catch (IOException e) {
    e.printStackTrace();
} 
}
}

我想要Excel工作表中的两列，其中第1列包含File或包含文件/文件夹名称的文件夹和列2 例如文件books.xml 文件夹脚本

因此我想将输出写入Excel工作表我正在使用excel日志功能写入输出屏幕

public static void printAtFile(String filename,String header,String content[]) { filename+=".csv"; System.out.println("Start creating file "+filename); PrintWriter writer = null; try { writer = new PrintWriter(filename); writer.println(header); for(String u:content) writer.println(u); writer.close(); } catch (Exception ex) { System.out.println("Error while writing at file "+filename); } }

我想将displayDirectoryContents的输出写入Excel工作表

epavelly 回答：我想将displayDirectoryContents的输出写入Excel工作表

大家都在问