Java写入Excel文件

通过java将数据写入Excel文件中

需要引入poi包

/**
 * 
 * 创建Workbook对象
 */
public Workbook createWorkbook(String path) {
    if (path.toLowerCase().endsWith("xls")) {
        return new HSSFWorkbook();
    } else if (path.toLowerCase().endsWith("xlsx")) {
        return new XSSFWorkbook();
    } else {
        return null;
    }
}

/**
 * 
 * 读取Workbook对象
 */
public Workbook readWorkbook(String path) throws IOException {
    FileInputStream in = new FileInputStream(path);
    Workbook workbook = null;
    if (path.toLowerCase().endsWith("xls")) {
        workbook = new HSSFWorkbook(in);
    } else if (path.toLowerCase().endsWith("xlsx")) {
        workbook = new XSSFWorkbook(in);
    }
    in.close();
    return workbook;
}

/**
 * 
 * 获取Workbook对象
 */
public Workbook getWorkbook(String path) throws IOException {
    File file = new File(path);
    if (file.exists()) {
        return readWorkbook(path);
    } else {
        return createWorkbook(path);
    }
}

/**
 * 
 * 写标题
 */
public void writeTitle(Workbook workbook, ArrayList
   
   
    
     list) {
    //生成一个表格    
    Sheet sheet = workbook.createSheet();
    //设置表格默认列宽度为20个字符    
    sheet.setDefaultColumnWidth(20);
    //生成一个样式，用来设置标题样式    
    CellStyle style = workbook.createCellStyle();
    //设置这些样式    
    style.setFillForegroundColor(IndexedColors.SKY_BLUE.index);
    style.setFillPattern(CellStyle.SOLID_FOREGROUND);
    style.setBorderBottom(CellStyle.BORDER_THIN);
    style.setBorderLeft(CellStyle.BORDER_THIN);
    style.setBorderRight(CellStyle.BORDER_THIN);
    style.setBorderTop(CellStyle.BORDER_THIN);
    style.setAlignment(CellStyle.ALIGN_CENTER);
    //生成一个字体    
    Font font = workbook.createFont();
    font.setColor(IndexedColors.VIOLET.index);
    font.setBoldweight(Font.BOLDWEIGHT_BOLD);
    //把字体应用到当前的样式    
    style.setFont(font);
    //产生表格标题行  
    Row row = sheet.createRow(0);
    for (int i = 0; i < list.size(); i++) {
        Cell cell = row.createCell(i);
        cell.setCellStyle(style);
        cell.setCellValue(list.get(i));
    }
}

/**
 * 
 * 写内容
 */
public void writeContent(Workbook workbook, ArrayList
    
    
     
      list) {
    Sheet sheet = workbook.getSheetAt(0);
    //生成并设置一个样式,用于设置内容样式    
    CellStyle style = workbook.createCellStyle();
    style.setFillForegroundColor(IndexedColors.LIGHT_YELLOW.index);
    style.setFillPattern(CellStyle.SOLID_FOREGROUND);
    style.setBorderBottom(CellStyle.BORDER_THIN);
    style.setBorderLeft(CellStyle.BORDER_THIN);
    style.setBorderRight(CellStyle.BORDER_THIN);
    style.setBorderTop(CellStyle.BORDER_THIN);
    style.setAlignment(CellStyle.ALIGN_CENTER);
    style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
    //  生成另一个字体    
    Font font2 = workbook.createFont();
    font2.setBoldweight(Font.BOLDWEIGHT_NORMAL);
    //  把字体应用到当前的样式    
    style.setFont(font2);
    //产生表格数据行  
    Row row = sheet.createRow(sheet.getLastRowNum() + 1);
    for (int i = 0; i < list.size(); i++) {
        Cell cell = row.createCell(i);
        cell.setCellStyle(style);
        cell.setCellValue(list.get(i));
    }
}

/**
 * 
 * 输出到文件中
 */
public void printWorkbook(Workbook workbook, String path) throws IOException {
    FileOutputStream out = new FileOutputStream(path);
    out.flush();
    workbook.write(out);
    out.close();
}