poi入门

最新推荐文章于 2024-07-10 16:39:04 发布

-万里晴空-

最新推荐文章于 2024-07-10 16:39:04 发布

阅读量387

点赞数

分类专栏：开发技巧

本文链接：https://blog.csdn.net/qq_35207917/article/details/86896253

版权

这篇博客介绍了如何使用POI库进行Excel文件操作，包括创建工作簿、薄片，设置单元格内容、时间类型、对齐方式、边框样式、填充颜色、合并单元格以及字体样式，并提供了详细的demo测试和截图示例。

摘要由CSDN通过智能技术生成

参考网址

入门程序

创建一个工作簿

一个xls就是一个工作簿

    Workbook wb = new HSSFWorkbook();
    ...
    try  (OutputStream fileOut = new FileOutputStream("workbook.xls")) {
   
        wb.write(fileOut);
    }

    Workbook wb = new XSSFWorkbook();
    ...
    try (OutputStream fileOut = new FileOutputStream("workbook.xlsx")) {
   
        wb.write(fileOut);
    }

创建一个薄片

一个工作簿含有多个薄片

    Workbook wb = new HSSFWorkbook();  // or new XSSFWorkbook();
    Sheet sheet1 = wb.createSheet("new sheet");
    Sheet sheet2 = wb.createSheet("second sheet");

    // Note that sheet name is Excel must not exceed 31 characters
    // and must not contain any of the any of the following characters:
    // 0x0000
    // 0x0003
    // colon (:)
    // backslash (\)
    // asterisk (*)
    // question mark (?)
    // forward slash (/)
    // opening square bracket ([)
    // closing square bracket (])

    // You can use org.apache.poi.ss.util.WorkbookUtil#createSafeSheetName(String nameProposal)}
    // for a safe way to create valid names, this utility replaces invalid characters with a space (' ')
    String safeName = WorkbookUtil.createSafeSheetName("[O'Brien's sales*?]"); // returns " O'Brien's sales   "
    Sheet sheet3 = wb.createSheet(safeName);

    try (OutputStream fileOut = new FileOutputStream("workbook.xls")) {
   
        wb.write(fileOut);
    }

创建一个单元格

   Workbook wb = new HSSFWorkbook();
    //Workbook wb = new XSSFWorkbook();
    CreationHelper createHelper = wb.getCreationHelper();
    Sheet sheet = wb.createSheet("new sheet");

    // Create a row and put some cells in it. Rows are 0 based.
    Row row = sheet.createRow(0);
    // Create a cell and put a value in it.
    Cell cell = row.createCell(0);
    cell.setCellValue(1);

    // Or do it on one line.
    row.createCell(1).setCellValue(1.2);
    row.createCell(2).setCellValue(
         createHelper.createRichTextString("This is a string"));
    row.createCell(3).setCellValue(true);

    // Write the output to a file
    try (OutputStream fileOut = new FileOutputStream("workbook.xls")) {
   
        wb.write(fileOut);
    }

创建一个时间类型的单元格

    Workbook wb = new HSSFWorkbook();
    //Workbook wb = new XSSFWorkbook();
    CreationHelper createHelper = wb.getCreationHelper();
    Sheet sheet = wb.createSheet("new sheet");

    // Create a row and put some cells in it. Rows are 0 based.
    Row row = sheet.createRow(0);

    // Create a cell and put a date value in it.  The first cell is not styled</