Apache POI允许无涯教程为excel文档设置标题。它提供Sheet接口的 getHeader()方法,并返回Header类型的实例。
看一个示例,在该示例中将为文档创建和设置标题。
链接:https://www.learnfk.comhttps://www.learnfk.com/apache-poi-word/apache-poi-excel-header.html
来源:LearnFk无涯教程网
package poiexample; import java.io.FileOutputStream; import java.io.OutputStream; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Header; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; public class HeaderExample { public static void main(String[] args) { try (OutputStream fileOut = new FileOutputStream("Learnfk.xls")) { Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet("Sheet"); //创建标题 Header header = sheet.getHeader(); header.setCenter("Center Header"); header.setLeft ("Left Header"); header.setRight ("Right align Header"); // 创建行 Row row = sheet.createRow(4);//Creating a row Cell cell = row.createCell(1);//Creating a cell cell.setCellValue("Hello, Javaipoint!"); wb.write(fileOut); }catch(Exception e) { System.out.println(e.getMessage()); } } }
输出:输出是文件的printview。
祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)