如何将文件夹下所有文件名称提取到Excel表格中
excel删除超链接的3种方法
JAVA 读取文件夹中的文件名,生成EXCEL表格!
java读取文件夹下所有文件(包括子文件夹)的文件名
Java读取指定文件下的文件名到Excel中
public static void createTitle(HSSFWorkbook workbook,HSSFSheet sheet){
HSSFRow row = sheet.createRow(0);
sheet.setColumnWidth(0, (int)(20+0.72)*256);
sheet.setColumnWidth(1, (int)(30+0.72)*256);
HSSFCellStyle style = workbook.createCellStyle();
HSSFFont font = workbook.createFont();
font.setBold(true);
style.setAlignment(HorizontalAlignment.CENTER);
style.setFont(font);
HSSFCell cell;
cell = row.createCell(0);
cell.setCellValue("字名");
cell.setCellStyle(style);
cell = row.createCell(1);
cell.setCellValue("书法家");
cell.setCellStyle(style);
cell = row.createCell(2);
cell.setCellValue("书体");
cell.setCellStyle(style);
cell = row.createCell(3);
cell.setCellValue("朝代");
cell.setCellStyle(style);
cell = row.createCell(4);
cell.setCellValue("来源");
cell.setCellStyle(style);
cell = row.createCell(5);
cell.setCellValue("文件格式");
cell.setCellStyle(style);
}
public static void buildExcelFile(String filename,HSSFWorkbook workbook) throws Exception{
FileOutputStream fos = new FileOutputStream(filename);
workbook.write(fos);
workbook.close();
}
public static void main(String[] args) throws Exception{
String path = "D:\\书法行\\测试用";
File file = new File(path);
File[] fs = file.listFiles();
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("字库表");
createTitle(workbook,sheet);
int rowNum = 1;
for(File f : fs){
if(!f.isDirectory()){
String s = f.getName();
String[] strArr = s.split("\\_");
HSSFRow row = sheet.createRow(rowNum);
for(int i = 0;i<strArr.length;i++){
row.createCell(i).setCellValue(strArr[i]);
}
rowNum++;
}
}
String fileName = "D:\\file\\字库.xls";
buildExcelFile(fileName,workbook);
System.out.println("生成完成");
}